this post was submitted on 13 Jun 2023
253 points (100.0% liked)

Technology

1928 readers
7 users here now

Rumors, happenings, and innovations in the technology sphere. If it's technological news, it probably belongs here.

Subcommunities on Beehaw:


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS
 

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!

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago (4 children)

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?

[–] [email protected] 2 points 1 year ago

I believe CSV format has quoting rules. Hope the software understands them. :)

[–] [email protected] 2 points 1 year ago (2 children)

Csv is not always comma delimited. It could also be delimited with a tab, semicolon, or pipe (|)

[–] [email protected] 3 points 1 year ago (1 children)

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.

[–] [email protected] 4 points 1 year ago

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

[–] [email protected] 1 points 1 year ago

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.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

you can enclose the contents of a field in double quotes so that commas within a field don't break it.

[–] [email protected] 1 points 1 year ago

so I just looked at the .csv it spat out, it encloses everything in quotes. here is what it looks like with the actual details changed:

"Title","Body","Permalink","Score","Timestamp UTC","Actions",

"","example comment start, example comment middle, example comment end","https.../","2","1686084708","deleted ",

HOWEVER, looking at this .csv I don't think it actually exported all of my comments. I don't really care about saving my reddit comments but I'm 99% sure it is missing my oldest comments from this account so use at your own risk I suppose

it did a wonderful job of deleting everything though, my account looks totally empty from the profile page