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

Horton Works

Hortonworks is a leading innovator in the industry, creating, distributing and supporting enterprise-ready open data platforms and modern data applications. Our mission is to manage the world’s data. We have a single-minded focus on driving innovation in open source communities such as Apache Hadoop, NiFi, and Spark. We along with our 1600+ partners provide the expertise, training and services that allow our customers to unlock transformational value for their organizations across any line of business. Our connected data platforms powers modern data applications that deliver actionable intelligence from all data: data-in-motion and data-at-rest. We are Powering the Future of Data™.