JuliaData/CSV.jl

Wishlist : import percent or currency formatted data

Opened this issue · 0 comments

As for dateformat, it would be nice to be able to define currency or percent format and to import columns directly as float values instead of strings.

For example
if specified currency="$", "$100" would import as 100
if specified currency="€", "90€"' would import as 90
if specified percent="%", "50 %" would import as 50

An alternative could be to just be able to ignore characters or substrings:

For example;
if specified ignore="CHF", a column containing "70.00 CHF" would be considered as 70.00 and imported as Float 70.