A Python3 script for fixing CSV files with “quoting” problems.
This tool is able to repair only a specific case: when one or more quotation marks exist inside a quotation marks surrounded field. These characters need to be escaped to be handled correctly by the CSV reader.
The fix applied consists on the doubling of each quotation mark found inside these fields.
You have to run it from command line, adding at least the CSV source file as parameter. A quick usage is printed with -h or without any parameter.
You can find the whole project on github.