News for hackers. Stuff that matters.

A comment on How to Analyze Every Reddit Submission and Comment, in Seconds, for Free. Parent comment

Re:How to Analyze Every Reddit Submission and Comment, in Se... by Pxtl on Saturday October 03, 2015 @02:10PM (#10324792)
Microsoft often fails with CSVs actually. I've found I can't copy/paste from Sql Server Management Studio into Excel if you have a mismatched double-quote in a cell - it fails silently and garbles your data.

That was embarrassing.

The CSV format is so messy that even big corporate implementations will have subtle bugs like that. Do not trust it.

[ Parent | on HN ]
Re:How to Analyze Every Reddit Submission and Comment, in Se... by 0x0 on Saturday October 03, 2015 @03:08PM (#10324991)
Microsoft excel has the worst CSV defaults. The separating character is even locale-specific! Many locales use semicolon ";" instead of "," as a separator. Great stuff when creating web app exporters.
[ Parent | on HN ]