Importing Flat Files with Newline Characters in Informatica

During a project that included loading flat file accounting data, I came across a very interesting issue. We were given multiple comma-delimited csv files with several fields utilizing a double quote text qualifier. Normally this would not be an issue; however inside the double quotes were newline characters.

Below is an example of the issue with the AUDIT_SCHEDULE_REQUEST column from one row of data.

Articles & Resources

To access this premium content, please fill out the form to receive an email with the access token.

* required fields