I use the inputlookup file.csv and the zeros on numbers are deleted ex. 00075 to 75, it also truncates some numbers ex. 20170505.00002 to 20170505
How do I get it to input CSV data exactly as it is?
Hi @shealerner
There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.
Hi @shealerner
There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.
Thank you, I was opening the file in Microsoft Excel which was truncating the values.
Welcome. Please accept my answer.