I'm using tFileInputDelimited to read csv file :
As we can see in above screenshots, CustomerNumber field contains alphanumeric values(some might be numeric and some might be string). I want the values as it is so I used String type.
But why its giving '0000001' instead of '1' ?
Please help. Thanks !
Solved! Go to Solution.
No problem. It is also wise to avoid opening CSV files in Excel. Excel can completely change the CSV format if you save them within Excel. This can cause big issues with debugging
Some other issues with opening csv files directly with Excel:
If you have no alternative means to examine a csv file, at the very least you should "Import" the data. In Excel 2010, this is done from the Data tab -> Get External Data -> From Text
Import everything as text to see what it (almost) looks like in the file. You still won't see quote enclosures, but you'll at least avoid issues like 0000001 being represented as 1 and get to see the date formats in use by the file.