We are receiving a Flat file which contains new line character in one of the field.
We are using following configuration to have fields as double quote limited.
This is still causing Map and process to fail. How can we handle it?
Please make sure that the Flat file you are picking up has the File Delimiter of type Tab, if not please make the necessary changes as per the file. Also, since it is a flat file the Use Column Header Check Box must only be checked if your requirement as per the flat file is to make the first row as the header, if not then please un-check that option as well.
HiShivam Pandey, it seems you did not get my question correctly. This file is TAB delimited only. There is no issues with Header row. But in the data rows, one of the field value contains a new line character (Line Feed - LF) in itself. Content of this field is enclosed in double quotes already. Now, I want to process this file.
Did you use the flat file wizard? Generating aflat file profile with the Import Wizard
Your requirement is not clear. Can you share sample file and how you are are generating your FF profile? And also share the error log you receive while running the process.
Hi, I found the root cause. One of the profile was missing "Text Qualifier Escape" setting, this was causing map and other components to break. After setting it to double quotes, it worked fine.
Sorry for the trouble.
Retrieving data ...