3 ms·
This is why I switched to TSV. The risks are too high. (Yes, I know about ASCII delimiters, but IMHO /t and /n are good enough for numbers-first files, especia
by BlueTemplar 6y ago
This is why I switched to TSV. The risks are too high.
(Yes, I know about ASCII delimiters, but IMHO /t and /n are good enough for numbers-first files, especially considering how most keyboards don't feature the aforementioned delimiters, and hardly anyone has even heard of them.)
https://ronaldduncan.wordpress.com/2009/10/31/text-file-formats-ascii-delimited-text-not-csv-or-tab-delimited-text/ https://ronaldduncan.wordpress.com/2009/10/31/text-file-form...
- throw0101a 6y agoWith commas one uses "CSV" as the file extension, and with tabs presumably TSV. Is there a file extension and MIME type for ASCII-delimited files? ASV?
- masklinn 6y agoCSVs are ascii-delimited. Do you mean files using US as field separator?
- formerly_proven 6y ago.gop?
- throw0101a 6y agoYes. If I want to use the 0x1c to 0x1f in a delimited file, how would I signal by file extension (and/or MIME type) that is what is happening?
- xnx 6y agoTSV is a lot better, but still isn't great for tabs in fields (rare) and line breaks in fields (more common). One nice characteristic of tab-delimited is you can typically copy all the text from a text editor and paste right into a spreadsheet.
- chubot 6y agoI'm fixing this with a smooth upgrade to QTSV: https://news.ycombinator.com/edit?id=25022836 https://news.ycombinator.com/edit?id=25022836 Each cell is QSN, which can contain tabs and newlines: http://www.oilshell.org/release/latest/doc/qsn.html http://www.oilshell.org/release/latest/doc/qsn.html The nice thing about this is that you can import QTSV into ANY program that accepts TSV. A QTSV file is syntactically valid TSV. You may have to do an extra step to dequote certain fields, but that's better than a completely new format that doesn't import at all. Let me know if you want to help :)