Re:Friends don't let friends export to CSV
by bee_rider on Tuesday March 26, 2024 @12:06AM
(#39824197)
Would it be possible to just type the file using commas, semicolons, or pipes or something (whatever you happen to know you don’t have in your file) and then convert them using sed?
[ Parent
| on HN ]
Re:Friends don't let friends export to CSV
by deathanatos on Tuesday March 26, 2024 @12:59PM
(#39830153)
Yes, it would be possible. You'd have to make sure the character didn't appear / no escaping at all was present, which the data may or may not allow.
Might as well just get a dedicated CSV→USV converter, though.
(I have a variant of this problem in JSON→YAML … usually I just shove one into the other & pray, akin to your sed solution.)