CurrencyToNumeric: Currency String To Numeric

In phively/wranglR: R Data Wrangler

Description

This function takes a vector or data frame of currency values in character format, strips out comma delimiters and currency symbols, and converts the result to numeric.

Usage

CurrencyToNumeric(data, fields = NA, debug = FALSE)

Arguments

data	Data frame or character vector to be manipulated
fields	Character vector of fields; not necessary if passing a vector
debug	If TRUE, print debug output

Examples

cash <- c("10,203¢", "$340", "€8,111.10", "£23,040", "¥8300")
CurrencyToNumeric(cash)

cash.frame <- data.frame(c1 = cash, c2 = cash, c3 = cash, stringsAsFactors = FALSE)

CurrencyToNumeric(cash.frame)
# Note that this unlists the data because no fields were included

CurrencyToNumeric(cash.frame, fields=1:2)
CurrencyToNumeric(cash.frame, fields=c("c2", "c3"))

phively/wranglR documentation built on April 11, 2020, 5:12 a.m.