Dealing with a badly formatted CSV file
- by Josh K
I have an exceptionally bad CSV file. Although I "solved" the problem in the end by manually writing scripts to process and reprocess this specific file I wanted to know if there were any other solutions out there.
You have a CSV file that has all the fields terminated by | (pipe) characters. Running a quick check shows you that there are 53…