3 ms·

Most csv utilities support an alternative delimiter. If I need to edit a file by hand, I'll typically pick an uncommon character for the delimiter (pipe "|" wor

Most csv utilities support an alternative delimiter. If I need to edit a file by hand, I'll typically pick an uncommon character for the delimiter (pipe "|" works well since it's uncommon). For me, that pretty much entirely eliminates any of the pain with CSV.

riffraff 5y ago
tab-separated-value has never betrayed me! I think it's the default postgresql file export too.
- atoav 5y ago
  As long as the fields are quoted and escaped : )
fiddlerwoaroof 5y ago
More tools should use the ASCII unit and field separator characters intended for this purpose: 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...
- mro_name 5y ago
  wow, the solution hides in clear sight right before our eyes. Once again.
- vim-guru 4y ago
  This is gold
- cylinder714 4y ago
  See also Control Character Separated Values: https://www.ccsv.io/ https://www.ccsv.io/