• sylver_dragon@lemmy.world
    link
    fedilink
    English
    arrow-up
    1
    ·
    6 days ago

    Sadly, no. CSV files can deal with embedded commas via quoting or escaping. Given that most of the dumps are going to be put together and consumed via common libraries (e.g.python’s csv module), that’s all going to happen automagically.

    • nymnympseudonym@piefed.social
      link
      fedilink
      English
      arrow-up
      1
      ·
      6 days ago

      Can be != will be

      You’re looping over 50M records, extracting into your csv. Did you bother using the appropriate library, or did your little perl script just do split(/,/,$line)