Pipe delimited file has semicolon caused error output file, data missing

[Anonymous]

We have 2 rows data in pipe delimited file, 1 row with Semicolon ";". After mapping and tFileoutputDelimited component, row data after ";" are missing. Source Conrad|M|Yan|"Conrad;Yan"|||12/16/1960||M|M||B|||SSN Ivan|M|Yang|Ivan|||12/16/1960||M|M||B|||SSN Result "GLOBAL"|"Conrad"|"M"|"Yan"|""|"Conrad "GLOBAL"|"Ivan"|"M"|"Yang"|""|"Ivan"|""|""|""|""|""|""

[fdenis]

check your tfileinput it's working for me.

[Anonymous]

It is not work in tFileOutputDelimited component (Pipe delimited)

[Anonymous]

@yjqziliao check in your designer section in tFileOutputDelimited whether pipe is used as a delimiter. If not, please use them.

Data will be moved to another column if ; is the delimiter, since you have ; in the data

Thanks,

Prabuj

/ Don't forget to give kudos /

[fdenis]

did you have "\n" in row separator.
Or did you have ";"?

[Anonymous]

@yjqziliao once you fixed it. Please mark the topic as resolved.

Thanks,

Prabuj

/ Don't forget to give kudos /