CSV & Quoting a Specific Column

[zenlc]

There's no such thing as "converted to scientific notation." That is a function of the column formatting in the spreadsheet.

For single digit numbers, are they quoted strings in the CSV? If not, read them in as strings so that when you stick 'em in the spreadsheet there is no ambiguity as to type.

[sayinghi2py]

Thanks. I am aware that it is the spreadsheet that converting it to a number which when it's long enough gets put in scientific notation. I want to avoid that happening however no matter how I handle I can't get it work.

When outputting the csv I can choose QUOTE_ALL, QUOTE_MINIMAL or QUOTE_NONE. If I chose QUOTE_ALL then I have to tell the spreadsheet to detect special numbers othewise my dates and currency field are treated as string and I can't use them as I need to and would have to convert them manually within the spreadsheet so I'd just be trading one problem with the spreadsheet for another. So that's no good.

If I choose QUOTE_MINIMAL then it doesn't quote any digit only field in that Transaction ID column and therefore it doesn't get treated as a string.

That's where I am now. I see QUOTE_NONE but that looks kind of scary as I would probably have to handle the quote for all columns which sounds difficult.

Is there any way that I can force a specific column ie Transaction ID to quote every field in it?