3 ms·
"The problem is that the CSV file format has no reliable mechanism to mark a column as text( )."* The problem is that there is NO such thing a "the CSV file f
by gngeal 14y ago
"The problem is that the CSV file format has no reliable mechanism to mark a column as text( )."*
The problem is that there is NO such thing a "the CSV file format". There's only a lot of different interpretations of how to store data in forms of rows with fields separated by commas or semicolons or whatnot, with every software package having slightly different ideas.
Save the world, use S-expressions or JSON if you write something new.
- MichaelGG 14y agoCSV is not the issue here; Excel's automagic conversions are. If it could open JSON, it'd extract the values, then apply it's magic. So your JSON string "DEC1" would still be converted (JSON doesn't have a date type).