Note that the interpretation of CSV files in the wild is all over the map, that RFC is not a very high authority on how things actually work with CSV processing in software you encounter.
What to use in stead: https://news.ycombinator.com/item?id=30626573
Should fix all those issues, AFAICS.
So of course abloslutely nobody uses it. :-(
> If fields are not enclosed with double quotes, then double quotes may not appear inside the fields.
Feels to me like a lot of manual implementations will break this assumption if they naively only try to deal with line breaks and delimiter escaping.
Either way, CSV is fraught enough format that I wouldn't try to ingest files of from unknown sources or from unknown generators.