I've written a commercial, point and click, data wrangling tool (Easy Data Transform) that can deal with a lot of these issues: -different delimiters (comma, s

I've written a commercial, point and click, data wrangling tool (Easy Data Transform) that can deal with a lot of these issues: -different delimiters (comma, semi-colon, tab, pipe etc) -different encodings (UTF8, UTF16 etc) -different line ending (CR, LF, CR+LF) -ragged rows -splitting and merging columns And much more besides. However, if you have either: -line feeds and/or carriage returns in data values, but no quoting or -quoting, but quotes in data values aren't properly handled Then you are totally screwed and you have my sympathies!