News for hackers. Stuff that matters.
Re:Working with CSV files on shell/terminal by RobinL on Wednesday June 28, 2023 @03:12AM (#36503343)
I think the fundamental issue is that a single 'cell' (value) can contain newlines, so you can't just assume each line is a 'row' and trivially parallelize.

The problem is perhaps most obvious when you consider that the value of a single cell could itself be a CSV, and this could be recursive

Re:Working with CSV files on shell/terminal by wenc on Wednesday June 28, 2023 @12:51PM (#36509138)
I haven’t worked out if the BNF is unambiguous (RFC 4180) but if you have a CSV in a cell you would escape any ambiguous characters.

An unescaped cell within a CSV will break most CSV parsers in the world even with recursion handling.

https://datatracker.ietf.org/doc/html/rfc4180