Filter out single and double quotes from CSV

[mfhepp]

Sometimes, it is unavoidable that CSV files contain single or double quotes for string values.

Pantable seems to include them in the resulting tables, which does not look very nice:

prefix, city_or_region, comments, Status
'030', 'Berlin', 'My comment', True
'069', 'Frankfurt', , False
'089', 'Munich', 'Another comment', True

It would be nice to be able to tell Pantable to remove single and double quotes from field values.

[alerque]

I don't think those are necessarily even valid CSV files, mixing single quotes and no quoting in a single file is just ... bogus. The spec only allows for double quotes. I'm not saying those things (and other problems such as tab/space or use of things other than commas for delimiters do happen in the wild. I just suggest you normalize your CSV data using other more robust tooling (I recommend csvkit tools) first thing after receiving it before you hand it off to other tools like this one that assume properly-formed data. All downstream tools should not be responsible for parsing all the possible broken formats that might exist in the wild.