A small program that converts a CSV file into character separated fields. Taking care of quoting and escaping. The code is generalized to allow the definition of the:
Running csv2txt explicitly specifying the defaults
csv2txt -D ',' -O '|' -L '"' -R '"' -e '\' myfile.csv(A)typical input
"Unger, Felix",1972,sitcom,"30 60" Unger\, Felix,1972,sitcom,30 60Output
Unger, Felix|1972|sitcom|30 60 Unger, Felix|1972|sitcom|30 60
Source in files/
This program scratched an itch when I was sent large excel spreadsheets of accounts with email addresses and was trying to resolve duplicates etc I found it easiest to convert the sheets to CSV (which itself has a rubbery specification) and then to character separated fields with all quoting and escaping removed. Applying unix text tools - cut, paste, sort and join - was the simple part.
Converting from the separated field format to csv and then to excel is left as an exercise.
Creative Commons CC0 http://creativecommons.org/publicdomain/zero/1.0/legalcode