Understand numbers with special characters
Overview
When loading data through ASCII data readers, I have run into challenges with special characters in numeric fields not loading. Dollar signs and commas are the most frequent. BOARD does not understand that $12,345.67 is a number. I have to add string manipulation steps in ETL to parse out the dollar sign and comma. I’m sure there are other international special characters that would have the same challenges. If BOARD could natively understand this as a number, the data reader would be faster to develop and run.
Feature
For ASCII datareaders, regional formats of numeric values will be understood as valid numeric values without needing additional ETL string manipulation.
Benefits
- Data reader performance will improve
- Data errors will be reduced
- Developement time will be reduced