"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.
Except when it uses semi-colons. Or pipes. Or something else.
When the delimiter is different, you have a different file format. TSV (tab-separated values) is an example of this.
https://en.m.wikipedia.org/wiki/C0_and_C1_control_codes#Fiel...
https://successfulsoftware.net/2022/04/30/why-isnt-there-a-d...
And discussed at HN here:
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'.
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)
Slightly on-topic: I found what LibreOffice Calc has a decent input wizard which most of the time works and good enough.