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

Four Stars

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

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

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

Capture.PNG

 

check your tfileinput it's working for me.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

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

It is not work in tFileOutputDelimited component (Pipe delimited)
Seven Stars

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

@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

Capture8.PNG

 

Thanks,

Prabuj

/ Don't forget to give kudos /

 

Twelve Stars

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

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Seven Stars

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

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

 

Thanks,

Prabuj

/ Don't forget to give kudos /

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog