Wishlist : import percent or currency formatted data
Opened this issue · 0 comments
Pascal-ascii commented
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.