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!

  • Pete Hahnloser@beehaw.org
    link
    fedilink
    English
    arrow-up
    1
    ·
    2 years ago

    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?

    • Cipher@beehaw.org
      link
      fedilink
      English
      arrow-up
      2
      ·
      2 years ago

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

      • T0RB1T@beehaw.org
        link
        fedilink
        English
        arrow-up
        5
        ·
        2 years ago

        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.

        • Cipher@beehaw.org
          link
          fedilink
          English
          arrow-up
          3
          ·
          2 years 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

    • TheRtRevKaiser@beehaw.orgM
      link
      fedilink
      English
      arrow-up
      2
      ·
      2 years ago

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

    • lackthought@lemmy.sdf.org
      link
      fedilink
      English
      arrow-up
      1
      ·
      2 years 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