http://www.perlmonks.org?node_id=123584


in reply to Regular Expression help, MS Access Pipe delimited export gone bad

You may want to take a look at Text::xSV by our own tilly. This works like Text::CSV but handles embedded newlines. If you import your data into perl with Text::xSV you could then export it in a format more suitable for MySQL (perhaps using quoted fields as gt8073a already pointed out.