Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I didn't like CSV because too much actual data has commas in it, so commas aren't a good delimiter.


From the perspective of reading/writing CSVs programmatically, I actually prefer that it's a common character. You'll discover very quickly whether the parser handles escapes correctly. With a more exotic delimiter it might be a long time to discover the problem, and by then it will be harder to fix.

From the perspective of writing CSVs by hand in a text editor, commas suck.


Tabs are a better delimiter than commas. Using the ASCII control characters meant for record and field delimiters are even better: https://en.wikipedia.org/wiki/C0_and_C1_control_codes


Quoting every column is a safe way to handle this, at the cost of slightly larger files. You can then escape a quote with another quote.


That is just one simple problem. People say CSV is hard because it is hard: https://www.delimited.dev/csv-file-quirks/




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: