Small steps

Photo by Mika Baumeister on Unsplash

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.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store