I'm pulling from a databases columns that have free text that sometimes contains many lines of data in one field.  Everything appears to be fine until I try to land the data to a file.  It writes the file correctly, with each row spanning multiple rows.  But I can't get Talend to read in the files with a tFileInputDelimited component, and the Data Viewer option also gives the same error with red null for each row.  I've tried many different values for my row separator, including "¶\n" and "*!*!*".

I believe Talend, via Java, is reading in one line at a time and assuming that it contains an entire row.  Is there some way to make it read until the row separator string is encountered?