I've recently faced issues with Google Docs exported sheet, since (of course) it does not escape quotes. The issue happens if field starts with quoted value, but then continues unquoted. Minimal reproduction case would be:
Lewis;Huey;"Hip To Be Square" by Huey Lewis and the News
It chokes on the \space right after second quote. I'd expect it to thrown an exception with strict = true, but with strict = false I'd like it to recover into:
["Lewis", "Huey", "\"Hip To Be Square\" by Huey Lewis and the News"]
I did manage to prototype a fix within parse-csv-line to achieve this, it would however affect quoting related change done in 2.0.2 -- as it modifies default behavior (with strict = false). Strict mode still fails as expected. Related 2.0.2 quoting tests are currently a regression and would have to be moved to strictness tests section.
i0cus
commented
7 years ago
Hi David,
I've recently faced issues with Google Docs exported sheet, since (of course) it does not escape quotes. The issue happens if field starts with quoted value, but then continues unquoted. Minimal reproduction case would be:
It chokes on the \space right after second quote. I'd expect it to thrown an exception with
strict = true, but withstrict = falseI'd like it to recover into:I did manage to prototype a fix within
parse-csv-lineto achieve this, it would however affect quoting related change done in 2.0.2 -- as it modifies default behavior (withstrict = false). Strict mode still fails as expected. Related 2.0.2 quoting tests are currently a regression and would have to be moved to strictness tests section.Would you be interested?