How to read flat file source that contains carriage return in one of its columns.

Reading Carriage return as a part of Column value from flat files.

If you face any issue while reading data from flat file which contain carriage return as a part of data.Then look into this post you can solve it.

Consider the following Pipe delimited flat file which contains 3 rows, but if you observe that the 2nd row contains  carriage return because of this informatica reads second row as 2|"test  and 3rd as row2"|4

                         Field1|Field2|Field3

                          1|"test row"|3

                          2|"test CR

                                   row2"|4

                          3|"test row3"|5

To sole this issue we need to read 2nd row 2nd field as "test CR      row2".

For this Informatica provides an easy way. Just follow the below steps to sole your issue.

1) Go to Informatica session and open it.

2) Click on Config Object.

3) Under Advanced section go to Custom Properties and click on Value. See the below picture.

4) After Clicking on Value you can see the below popup.

5) Now add new attribute value as below.

Attribute:- MatchQuotesPastEndOfLine

Value:- Yes

6) Click OK and save the session and execute your workflow.Now you can able to read the data from the file perfectly.

Hope you solved your problem with this solution . Share it with your colleagues if you like it . 

Share the knowledge that will enhance your skills.

Please enter the comments for any doubts and details.