News for hackers. Stuff that matters.
Re:Mistaken Identifiers: Gene name errors introduced inadver... by gngeal on Sunday April 21, 2013 @04:01PM (#5586187)
"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.

Re:Mistaken Identifiers: Gene name errors introduced inadver... by MichaelGG on Sunday April 21, 2013 @07:13PM (#5586884)
CSV 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).