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
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP