I have a text file that has quoted text fields, a pipe delimiter for fields, and a linefeed (LF) character for end-of-line designation.  A sample of the file is attached.

However, there are a few records within the field called "general_comments" which contain LF characters in the text (row 19 in the attached).  This is causing the row to be parsed prematurely.

The use of quotes around the text is supposed to compensate for this and prevent row parsing, but PP seems to be ignoring the quoted text and still parses the text before the proper end-of-line.

Is there a way to get the text reader or delimited text reader components to honor the quoted text?  Or perhaps someone knows of a work-around to process the file?  I could see if the file supplier could switch to a CRLF end-of-line character, but there's still the possibility that CRLF will appear one day within quoted text as well.

Thanks,

Matt