I have a CSV file, fields surrounded by double quotes, comma separated. There are a bit more than 230K rows.
Some of the fields have hard returns in them, so it breaks my rows, and my importer (phpMyAdmin) chokes.
What’s the easiest way to remove only those hard returns? I’m thinking something like a fancy regex in vim to remove hard returns from the ends of lines that don’t end in double quotes, but my regex-fu isn’t that awesome.
Anyone know how to do that, or have a better idea?