3 ms·
TSVs are exactly unlike CSVs where it matters. The quoting rules for CSV are just bizarre, and also make it impossible to skip records without parsing every si
by 08-15 6y ago
TSVs are exactly unlike CSVs where it matters. The quoting rules for CSV are just bizarre, and also make it impossible to skip records without parsing every single field. TSV does the right thing: only three characters are special (line feed, tab, backslash) and to include them in fields, you escape them. This is totally unlike the mess that is CSV!
I also don't get why TSVs aren't more popular.
Ironically, even the only reason why CSV exists at all, MS Excel, likes TSV better. The only format that can be exported and imported without trouble is TSV, encoded in UTF-16 with a BOM. But everybody uses CSV anyway. Weird.