Data spiliting due to Pipe Delimiter in between Data

[abhi90]

Hi All,

I have File where a Row is present which is having Pipe delimiter inside Data. Now the File is itself Pipe delimited. and The Data is enclosed by Double Quotes. Now I am loading the file Data using tfileinputdelimited. where Rowseparator is "\n" and Field Separator is "|". If I am checking CSV Options and giving Escape Character as """ and Text Enclosure as "/"" Then 7 Rows is spliting badly. Can anybody please help?

@TRF, @rhall, @vboppudi, @TRF, @manodwhb. Data is like "Abhijit is walking|9P.M". Database Column is String.So  Abhijit is walking is going to intended Column and 9P.M is going to Next Column

[abhi90]

Hi @manodwhb,

Thanks for your awesome help.Yess. With your solution I handled | in between Data. And Other ETL of our project was loading data incorrectly. After I corrected that Data is accurate between Talend and Informatica. . Marking your solution as accepted. Hope to get this kind of help in future also