Hi experts,
The source file which is a csv has some phone number entries which are read as scientific exponential values (just the way it is shown in the excel sheet). For example; 1.22E+09 for 1215113944. When I open the source file it shows the exponential value, but when I click on the cell, it shows the correct value. It also shows correct value when opened using a text editor like notepad.
PI reads this file in the incorrect way and is also archiving it the same way.
Is there a way PI can read these numbers correctly?
Many thanks,
Ramesh.