this is improper CSV: odd number of quotes

[VladimirAlexiev]

perl -ne '@matches = m{(")}g; $matches=@matches; print "$matches quotes, line $.: $_" if $matches%2' \
   MetObjects.csv > bad-quotes.txt

156438 of 554403 rows have an odd number of quotes. This makes it broken CSV and nearly impossible to work with

• eg tarql cannot work with it (https://github.com/tarql/tarql/issues/50)
• I will now try csvkit

[VladimirAlexiev]

Maybe I spoke too quickly: there are newlines in some fields enclosed in quotes. Let me see with csvkit...

[VladimirAlexiev]

Yes, close this