I have a Microsoft application generated CSV file (encoded with MS's variant of Unicode), where certain fields can contain a newline.
To my demise, they are not quoted as they neither contain the field separator OR the Windows eol marker. E.g it looks like this:
text\ncontinued,"I have a comma, so I'm quoted",I don't\r\n
I've tried Text::xSV & Text::CSV, and both get trapped on the embedded newline.
Is there something I'm missing to coax either module (or another suggestion) to handle this cleanly ?