Frustrating CSV Conversion Issue

[CPGDeveloper]

Hi All,

I'm working on a script to export a query to a csv file. I'm having a very frustrating issue as certain numbers are being converted to scientific notation, despite initially setting the field to text in excel.

I am first exporting this query to excel, setting the column in question to text, and then saving it as a csv. When trying to open the csv, I get a conversion warning -- I select 'Don't Convert', and yet, some values are still converted. In the same column, some numbers are converted and some are not. It makes no sense to me.

All the values are entirely numeric -- oddly the values that are getting converted are 12 digits long, while the values that are not getting converted are 16 digits long. Image attached.

Any advice would be much appreciated.

 

[Joe4]

I am first exporting this query to excel, setting the column in question to text, and then saving it as a csv. When trying to open the csv, I get a conversion warning -- I select 'Don't Convert', and yet, some values are still converted. In the same column, some numbers are converted and some are not. It makes no sense to me.

Where exactly are you trying to open this CSV file?

If you TRULY want to see what the values in a CSV or any Text file look like, do NOT use Excel to view them! Excel will automatically perform its own conversions on them.
Try viewing the created CSV file in a text editor like NotePad to see how the values are TRULY stored in the CSV file.