News for hackers. Stuff that matters.

A comment on Friends don't let friends export to CSV. Parent comment

Re:Friends don't let friends export to CSV by vaylian on Tuesday March 26, 2024 @02:27AM (#39824768)
It kind of does. See `man ascii`

* FS (0x1C) file separator

* GS (0x1D) group separator

* RS (0x1E) record separator

* US (0x1F) unit separator

I've never seen these in the wild though.

[ Parent | on HN ]
Re:Friends don't let friends export to CSV by alex_suzuki on Tuesday March 26, 2024 @02:36AM (#39824809)
They‘re used a lot in barcodes, e.g. for delimiting the different fields of a driving license.
[ Parent | on HN ]
Re:Friends don't let friends export to CSV by euroderf on Tuesday March 26, 2024 @04:17AM (#39825297)
That sounds like the premise for an utterly fascinating deep dive.
[ Parent | on HN ]
Re:Friends don't let friends export to CSV by alex_suzuki on Tuesday March 26, 2024 @12:23PM (#39829661)
It‘s quite the rabbit hole, I can assure you.
[ Parent | on HN ]
Re:Friends don't let friends export to CSV by adammarples on Tuesday March 26, 2024 @08:15AM (#39826886)
Not seeing them in the wild is good, it means they will work when you use them. The more they get used the more often you'll find they crop up in the text fields you're trying to separate and the whole csv escaping nightmare will continue.
[ Parent | on HN ]
Re:Friends don't let friends export to CSV by Repulsion9513 on Tuesday March 26, 2024 @05:31PM (#39833111)
If you've got delimited-text embedded inside your delimited-text, you've got a nightmare that escaping can't save you from.

(obligatory https://knowyourmeme.com/memes/xzibit-yo-dawg)

[ Parent | on HN ]
Re:Friends don't let friends export to CSV by dhagberg on Tuesday March 26, 2024 @01:02PM (#39830184)
They're definitely used in ACARS messages that go to every commercial airplane cockpit...
[ Parent | on HN ]