News for hackers. Stuff that matters.
Re:Friends don't let friends export to CSV by hn_throwaway_99 on Monday March 25, 2024 @11:44PM (#39824083)
> The first time we came across CSV format we likely typed it in notepad by hand.

Again, I'm not saying CSVs aren't edited by hand in a text editor, I'm saying they aren't created from scratch in a text editor, even by beginners. USVs are easy to edit in a text editor, too, and I tried viewing and editing USVs with a couple different fonts and had no problems.

Re:Friends don't let friends export to CSV by iainmerrick on Tuesday March 26, 2024 @04:54AM (#39825564)
If the separators can't easily be typed, how do you add a new cell?
Re:Friends don't let friends export to CSV by scbrg on Tuesday March 26, 2024 @08:31AM (#39827033)
Nobody can type up a GIF image, or Word document in a Notepad, yet files of both those formats exist. The answer obviously is tooling. If a format with sane separators was common, so would editors that could edit that format be.
Re:Friends don't let friends export to CSV by iainmerrick on Tuesday March 26, 2024 @08:52AM (#39827223)
I was responding to the GP's:

USVs are easy to edit in a text editor

I don't see how that's the case.

If a format with sane separators was common, so would editors that could edit that format be

Sure, but that's a hypothetical future editor, not something that currently exists.

Edit to add: I also disagree with "sane" in that context. New separators won't solve anything. You'll always need escaping/encoding/encapsulation; get that right and everything else follows. JSON is comma-separated and does just fine.

Re:Friends don't let friends export to CSV by hn_throwaway_99 on Tuesday March 26, 2024 @09:50AM (#39827815)
Copy and paste.