News for hackers. Stuff that matters.
Re:Problems with CSVs by joshuata on Tuesday December 27, 2016 @04:25PM (#13266326)
Many of these problems could be avoided if we used the character codes for unit (31) and record (30) separator. This would avoid any problems with tabs or line feeds, as well as better matching the intended semantics of ASCII/UTF-8
Re:Problems with CSVs by kedean on Tuesday December 27, 2016 @04:28PM (#13266356)
That's suggested often, and the obvious rebuttal is that CSV is intended to be easily edited and relatively human-friendly. The unit/record characters are not on most(all?) keyboards, so editing the file in a text editor becomes pretty much impossible.
Re:Problems with CSVs by stouset on Tuesday December 27, 2016 @06:19PM (#13267146)
As a counterpoint, nobody seems to be editing CSV files by hand any more. It appears at this point to be an interchange format between different spreadsheets, row-oriented databases, etc.
Re:Problems with CSVs by kedean on Tuesday December 27, 2016 @06:40PM (#13267277)
I promise they're still used by hand all the time, usually as a form of supplying data to a program in cases where a database is just too much. CSV is still a very common base for data-driven unit tests.