topic Re: Pipe delimited file has semicolon caused error output file, data missing in Talend Studio

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

Anonymous — Thu, 13 Jun 2019 10:39:07 GMT

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"|""|""|""|""|""|""

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

fdenis — Thu, 13 Jun 2019 13:20:31 GMT

check your tfileinput it's working for me.

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

Anonymous — Fri, 14 Jun 2019 03:54:12 GMT

It is not work in tFileOutputDelimited component (Pipe delimited)

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

Anonymous — Fri, 14 Jun 2019 06:58:50 GMT

@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 /

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

fdenis — Fri, 14 Jun 2019 09:13:36 GMT

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

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

Anonymous — Fri, 14 Jun 2019 09:17:59 GMT

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

Thanks,

Prabuj

/ Don't forget to give kudos /