News for hackers. Stuff that matters.
Re:Turn Vim into Excel: Tips for Editing Tabular Data (2013) by sn41 on Saturday November 10, 2018 @10:34AM (#18421702)
I too don't see why tsv is better than csv. That said, as many people have pointed out, commas have legitimate uses in fields like Address of a locality etc. and this could cause a problem in scripting.

About exporting using random characters, I have found that ~ (tilde) is almost never seen in actual data, hence it can be used as a field separator in most cases. Another safe choice is the | (pipe) symbol. (In Windows, you can change the field separator in the "Region Settings" - a rather weird place to have that setting.)

Re:Turn Vim into Excel: Tips for Editing Tabular Data (2013) by zengargoyle on Saturday November 10, 2018 @01:54PM (#18422836)
Tilde is used in path names too much (~user), pipe is a logical OR. The best I've found is ^ (caret) which rarely shows up in real life.
Re:Turn Vim into Excel: Tips for Editing Tabular Data (2013) by frou_dh on Saturday November 10, 2018 @01:17PM (#18422592)
Tab is in the Control Character block of ASCII so that alone makes it strictly more appropriate