Learn R Programming

Ecfun (version 0.2-0)

parseDollars: Convert character string with Dollar signs and commas to numerics

Description

as.numeric of character strings after suppressing commas and dollar signs. This is a special case of parseCommas.

Usage

parseDollars(x, pattern='\\$|,', replacement='', ...)

Arguments

x

vector of character strings to be converted to numerics

pattern

regular expression to be replaced by replacement

replacement

Character string to substitute for each occurrence of pattern

optional arguments to pass to gsub

Value

Numeric vector converted from x.

Details

as.numeric(gsub(x, ...)). See also parseCommas.

See Also

gsub as.numeric parseCommas

Examples

Run this code
# NOT RUN {
##
## 1.  a character vector
##
X2 <- c('-$2,500', '$5,000.50')
x2 <- parseDollars(X2)

# }
# NOT RUN {
all.equal(x2, c(-2500, 5000.5))
# }
# NOT RUN {
##
## A data.frame
##
chDF <- data.frame(let=letters[1:2], Dol=X2, dol=x2)
numDF <- parseCommas(chDF)

chkDF <- chDF
chkDF$Dol <- x2
# }
# NOT RUN {
all.equal(numDF, chkDF)
# }

Run the code above in your browser using DataLab