Re:How to share your data effectively
by kyllo on Monday April 08, 2013 @04:48PM
(#5514487)
Yes, pipe-delimited format is great, and much easier to parse than comma-delimited.
Tab-delimited is also better than comma-delimited, I think.
Commas just have far too high a probability of appearing within the data itself, and when you hit a comma that was supposed to be escaped, it adds an extra column to the row, screwing everything up.
Re:How to share your data effectively
by jleader on Monday April 08, 2013 @08:41PM
(#5515730)
Tabs are great, until you try to explain to a non-programmer why your tool doesn't parse their file correctly, even though in the word-processor they're using as a text editor it looks identical to another file that parses correctly.
Tab-delimited is also better than comma-delimited, I think.
Commas just have far too high a probability of appearing within the data itself, and when you hit a comma that was supposed to be escaped, it adds an extra column to the row, screwing everything up.