Data Transformation Parsing Delimited File Financial Figures?
I have a CSV file that I would like to import to my data warehouse using Yellowfin's Data Transformations. That data has financial figures formatted using standard accounting formatting including dollar signs and parentheses for negative values.
How the heck am I supposed to parse these?
When I try to convert "$3.00" to numeric it chokes. I can't use a right substring because I don't know how long the number will be. The data calculator offers only numeric operators (+ - * /) so those are no help and there is no way to use free-hand SQL. Not sure how I would handle the harder case of parsing "($0.60)".