News for hackers. Stuff that matters.
Re:Friends don't let friends export to CSV by lolive on Tuesday March 26, 2024 @02:19AM (#39824734)
A manager: I wish I could have a CSV inside my CSV.

Any sane person: NO!

Re:Friends don't let friends export to CSV by bruce511 on Tuesday March 26, 2024 @04:07AM (#39825241)
Well you might be wrong, but EDI in general and HL7 specifically allow 3 levels of "fields in fields in field".

As long as your parser copes, and as long as you have appropriate structures to import into, its no big deal.

Re:Friends don't let friends export to CSV by iainmerrick on Tuesday March 26, 2024 @04:52AM (#39825547)
So now when I'm exporting data I need to know what nesting level it's going to live at so I can generate the correct separators?

I really think that might be the worst idea I've heard for a while!

Re:Friends don't let friends export to CSV by bruce511 on Thursday March 28, 2024 @10:52AM (#39852329)
It's not toooo bad :) But it's very much a "thing" in the real word. It's called EDI, and it's been around for a long time.
Re:Friends don't let friends export to CSV by josefx on Tuesday March 26, 2024 @02:27AM (#39824771)
base64 encoded fields it is.
Re:Friends don't let friends export to CSV by lolive on Tuesday March 26, 2024 @02:36AM (#39824806)
That was the right answer. You are hired!
Re:Friends don't let friends export to CSV by wiredfool on Tuesday March 26, 2024 @04:42AM (#39825473)
Been there, done the Interop.
Re:Friends don't let friends export to CSV by icedchai on Tuesday March 26, 2024 @09:47AM (#39827770)
About 10 years ago, I worked at a place where we were embedding both XML and JSON in CSV fields.

Then there are always the people who can't generate a valid CSV due to escaping issues...

Nothing is ever simple.