You are not logged in.
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?
Please describe your request with more details, so we give you precise answer.