News for hackers. Stuff that matters.
Re:How to share your data effectively by UnoriginalGuy on Monday April 08, 2013 @05:14PM (#5514655)
Where did that = sign come from? That isn't in the standard... Quotes are, but wtf? An equals sign? Fucking Excel.

JUST TREAT THE NUMBERS LIKE TEXT YOU STUPID PROGRAM.

000001 === 000001 != 1

Re:How to share your data effectively by niggler on Monday April 08, 2013 @05:21PM (#5514704)
It uses another auto trick: if the leading character is '=', the result is treated as a formula.

Thus, you can actually write formulas in your CSV and excel will interpret appropriately:

    $ cat test.csv
    =1+1,="1-5"
    $ open -a Microsoft\ Excel test.csv
You should see the value '2' (with content `=1+1`)
Re:How to share your data effectively by vacri on Monday April 08, 2013 @09:46PM (#5515987)
If you start using metacharacters, it's no longer a universal .csv, but an excel-specific one.