News for hackers. Stuff that matters.
Re:Excel: Error when CSV file starts with “I” and “D” by dpark on Wednesday July 06, 2016 @10:22AM (#12043213)
For files not intended to be hand-edited, it doesn't really matter what delimiters you use. It's not that difficult to code up char-escaping for csv.

At Yahoo, the typical delimiters for logs and whatnot were ctrl+a, ctrl+b, etc. It was slightly nicer than CSV, but only slightly. It was mostly nicer when manually inspecting files with columns that had embedded commas (that otherwise would have been escaped). The machines don't care, and for any interesting processing you'd often end up with escaping anyway.

There are no comments on this comment yet.