Re:Excel: Error when CSV file starts with “I” and “D”
by achr2 on Wednesday July 06, 2016 @09:35AM
(#12042936)
Part of your response is accurate as to 'why' dedicated separators never became mainstream - software compatibility - but frankly 99% of csv files were/are never meant to be hand edited, simply used as a neutral file. For the later usage, dedicated separators that do not require escaping or import settings would be major improvement.
[ Parent
| on HN ]
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.
Re:Excel: Error when CSV file starts with “I” and “D”
by sameerds on Thursday July 07, 2016 @12:16AM
(#12047454)
But csv files can also be manipulated in shell scripts, with the text being piped from one util to the next. Here it becomes important that the separators can be correctly typed and displayed.