4 ms·
A manager: I wish I could have a CSV inside my CSV. Any sane person: NO!
by lolive 3y ago
A manager: I wish I could have a CSV inside my CSV.
Any sane person: NO!
- josefx 3y agobase64 encoded fields it is.
- lolive 3y agoThat was the right answer. You are hired!
- bruce511 3y agoWell 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.
- iainmerrick 3y agoSo 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!
- bruce511 3y agoIt'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.
- wiredfool 3y agoBeen there, done the Interop.
- icedchai 3y agoAbout 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.