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


DocuSign® is changing how business gets done by empowering more than 250,000 companies and 100 million users in 188 countries to sign, send and manage documents anytime, anywhere, on any device, with confidence. Organizations of all sizes and industries are accelerating contracts, approvals and workflows with DocuSign’s Digital Transaction Management (DTM) platform and eSignature solution. DocuSign keeps life and business moving forward.