Or use tsv or xsv and never quote a field again.
Comment on 2x2 lumber at Home Depot is now 1.28x1.28. Nominal size is supposed to be 1.5
jaybone@lemmy.world 7 months agoIn CSV, you escape a double quote with a double quote.
aulin@lemmy.world 7 months ago
jaybone@lemmy.world 7 months ago
Sometimes we don’t get to pick what libraries and data formats we work with.
Especially with legacy systems and customer requirements.
aulin@lemmy.world 7 months ago
I know. I have nothing against the format in general, as it’s plain text and will always be readable. I actually prefer it to Excel sheets, although a proper database is the nicest. It’s just annoying that someone chose comma, a super commonly used punctuation mark, as default field separator for csv.
KISSmyOSFeddit@lemmy.world 7 months ago
In CSV you do whatever the fuck you want, and afterwards you delete the file cause CSV is trash and no one should use it.