Filter out single and double quotes from CSV #66

Activity

1. alerque commented on Mar 15, 2022

   

   alerque

   on Mar 15, 2022

   Contributor

   More actions

   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.
2. ickc

   added a commit that references this issue on Oct 6, 2026

   docs: read values in single quotes with csv-kwargs

   ...

   This issue will close once commit 62b7069 is merged into the 'main' branch.

   62b7069
3. ickc commented on Oct 6, 2026

   

   ickc

   on Oct 6, 2026

   Owner

   More actions

   This is already possible with csv-kwargs, which is passed to Python's csv.reader:

   ```table
   ---
   csv-kwargs:
     quotechar: "'"
     skipinitialspace: true
   ---
   prefix, city_or_region, comments, Status
   '030', 'Berlin', 'My comment', True
   '069', 'Frankfurt', , False
   ```

   quotechar makes single quotes the quoting character, and skipinitialspace drops the space after each comma so the quotes are recognised. Documented in 62b7069 (#71), on the Including a CSV file page. This closes when #71 is merged.
4. ickc

   closed this as completedin 62b7069on Oct 6, 2026