FixCSV

AttApps

This script fixes csv, txt or tsv files. It handles delimiters, quoted values and newlines. It has the option to break multiline cells into single lines, replicating the other columns.
The delimiter for the output file can be chosen (default is tab), and if present within a value, the value will be quoted regardless the option to remove it. CR+LF is the newline character for output file.
Handling NewLines
Handling Quotes
Quote Type
Delimiter and Removing Whitespace and Special Characters
For these special characters, use:
[TAB] for tab
[LF] for newline
[CR] for carriage return