[pitah1]

Good in-depth insights into each format. This complements nicely with a site I created called tech-diff (https://tech-diff.com/file/) where it provides a summary of the file formats.

[hermitcrab]

"Comma-Separated Values (CSV) is a text file format that uses commas to separate values in plain text."

Except when it uses semi-colons. Or pipes. Or something else.

[pitah1]

I was using the following RFC for the formal definition of CSV https://www.rfc-editor.org/rfc/rfc4180.html.

When the delimiter is different, you have a different file format. TSV (tab-separated values) is an example of this.

[justsomehnguy]

The most amusing thing is what there are symbols designated as separators

https://en.m.wikipedia.org/wiki/C0_and_C1_control_codes#Fiel...

[hermitcrab]

Oh yes. I wrote about that here:

https://successfulsoftware.net/2022/04/30/why-isnt-there-a-d...

And discussed at HN here:

https://news.ycombinator.com/item?id=31220841

[justsomehnguy]

Oh! Great article and, if the evil twist of fate would force me to write an export, I hope I would remember and use .usv

But I can't agree on 'default tools' - anything bigger than 3 columns is PITA to look at and I just Ctrl+H to replace the commas with tabs or \r\n (or whatever), depending on the format. At some point 'standart tools' doesn't matter anymore, because it doesn't worth to even use them on such files; think of 'jq'.

[hermitcrab]

>I just Ctrl+H to replace the commas with tabs or \r\n (or whatever)

That may not work if the CSV is escaped/quoted (e.g. because the data contains commas).

Or you could use our Easy Data Transform software. It pretty much handles all that horrible CSV stuff for you. ;0)

[justsomehnguy]

Of course, but most of the time I just need to have a quick glance at the data, or find a single value which I know where it should be.

Slightly on-topic: I found what LibreOffice Calc has a decent input wizard which most of the time works and good enough.