I have a string column that has values such as 00, 01, 02,03,04,05,06,07,08,09,10,11 and so on. I have a problem for values from 00 till 09. When i download this in csv format from a table visual, it is downloading as 0,1,2,3,4,5,6,7,8,9. Pls help me out on this one. Thanks
@lalprasanth Which application are you using to read the downloaded csv file?
There is a good chance that it is formatted in the number column, See f you can open it with nano or notepad and see if the problem persists.
Excel is what i am using but when i tried to open the same in notepad, all the values are falling as i expected like 00, 01…09. It is only with excel when i open up the csv file, it chooses to ignore the 0 and laying 0, 1, 2,3, 4…9. How can we resolve this? Appreciate ur help
As notepad can open the file correctly, it means the issue is on Excel, if you try searching “How to keep leading zeros when opening a CSV file in Excel” in search engine, then I expect you can get some solutions
Looks like Excel is recognize the values as number and therefore the 0 get lost.
If you insert 01 in a Excel cell it would happen as well.