Invalid CSV files

[dwillis]

Here's an example: the FEC is producing candidate and committee summary files (available here) that can contain interior double-quotes. Excel handles these just fine, but most programming language CSV parsers do not.

[waldoj]

Per suggestions made at the SRCCON discussion that spawned this issue, csvlint and csvclean are two tools that could be part of a solution to this problem.

[max-mapper]

my humble contribution https://github.com/maxogden/csv-spectrum