News for hackers. Stuff that matters.
Re:A love letter to the CSV format by mastax on Thursday March 27, 2025 @01:26AM (#43490607)
ASCII has characters more or less designed for this

0x1C - File Separator

0x1D - Group Separator

0x1E - Record Separator

0x1F - Unit Separator

So I guess 1F would be the "comma" and 1E would be the "newline."

Re:A love letter to the CSV format by afiori on Thursday March 27, 2025 @04:54AM (#43491573)
https://stackoverflow.com/questions/8695118/what-are-the-fil...

I am pretty sure you shifted the meaning, the decimal separator is part of the atomic data it does not need a control character.

You would use 1F instead of the comma/semicolon/tab and 1E to split lines (record means line just like in SQL).

You could then use 1D to store multiple CSV tables in a single file.

Re:A love letter to the CSV format by pasc1878 on Thursday March 27, 2025 @07:20AM (#43492419)
Yes but then the text is not human readable or editable in a plain text editor.

This would confuse most users of csvs they are not programmers they at most use text editors and Excel.

Re:A love letter to the CSV format by afiori on Thursday March 27, 2025 @12:18PM (#43495155)
I am not proposing to do this, but if you were to use ascii separators you would do it this way