In CSV, you escape a double quote with a double quote.
Comment on 2x2 lumber at Home Depot is now 1.28x1.28. Nominal size is supposed to be 1.5
FigMcLargeHuge@sh.itjust.works 5 months agoYou have to escape the quotes…
“2\"x4\"” or use differing quotes ‘2"x4"’
jaybone@lemmy.world 5 months ago
KISSmyOSFeddit@lemmy.world 5 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.
aulin@lemmy.world 5 months ago
Or use tsv or xsv and never quote a field again.
jaybone@lemmy.world 5 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 5 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.
mortimerkahn@sh.itjust.works 5 months ago
I think this is an excellent time to point out that curl quotes (“ ”) are what are typographically used for quotations and apostrophes and hash marks (" ‘) are what are used for feet and inches. So it would look something like:
“ 2"× 4’ ”
(Spacing is still a bit ugly, I’d kern me some quote marks)