Remove whitespace, replace quotes and remove NUL bytes.

ncvo / charity-commission-extract

Python utilities for handling the import of data from the Charity Commission data extract

43 stars 21 forks source link

Open matthewlilly opened 4 years ago

matthewlilly commented 4 years ago

Updated the convert function within bcp.py to avoid any errors when reading the converted csv files.

There were many instances where commas within strings were being read as a delimiter.
There were many NUL bytes causing error when being read.