I'm trying to create an external file format to create an external table off of a csv file with a simplified example row shown below consisting of three string fields (the last being html):
foo,bar,"<div id=""myId"">\n<p>hello</p>\n</div>"\n
it seems, that all the '\n''s including those inside the last field are creating new lines.
Is there a way to escape the html \n while honoring the 'actual' \n that occurs at the end of the row?