hey everyone. if you want to post links or discuss the Reddit blackout today, please localize it to this thread in order to keep things tidy! Thanks!
hey everyone. if you want to post links or discuss the Reddit blackout today, please localize it to this thread in order to keep things tidy! Thanks!
Archiving copies of my Reddit history would be nice, but here’s a somewhat idiotic question.
I use commas in copy a lot, so a CSV file sounds like a nightmare. How’s that handled?
Csv is not always comma delimited. It could also be delimited with a tab, semicolon, or pipe (|)
Isn’t a tab delimeted spreadsheet normally called a TSV, as in “Tab-Separated Values”?
Isn’t CSV literally Comma-Separated Values?
Sorry, pedantry doesn’t die.
A little bit yes, a little bit no
Tab delimited csv are sometimes called tsv, but just as often you’ll see csv (tab delimited) as a file type option
See the wiki section on standardization for details.
Csv currently includes the following delimiters:
Comma, space, tab, pipe, or semicolon
Now that you point it out, I remember being able to set delimiters on exports. It’s just been ages since I was generating them.
I believe CSV format has quoting rules. Hope the software understands them. :)
you can enclose the contents of a field in double quotes so that commas within a field don’t break it.