topic Re: Error in tfileoutputdelimited. in Talend Studio

Error in tfileoutputdelimited.

Anonymous — Sat, 16 Nov 2024 09:00:47 GMT

Hi All,

I am trying to create pipeline separated .mnt file, as my data contains arabic language in one of the column ,1 line is spliting into 2 lines.

Please find attached screen shot for mapping

As i am unable to attach .mnt file here i just saved the same as .txt file and attached

Kindly anyone help me on the same.

Re: Error in tfileoutputdelimited.

Anonymous — Mon, 27 Nov 2017 05:49:55 GMT

Hello,

Are you looking for "Split output in several files" option in advanced settings of tfileoutputdelimited component?

Best regards

Sabrina

Re: Error in tfileoutputdelimited.

TRF — Mon, 27 Nov 2017 08:43:53 GMT

Hi,

As soon as you have records splitted on several lines, they must be enclosed (usually) by " else you will be unable to decide where the records finish.

For that, go to advanced setting then tick the option "CSV options" (" is the default for text enclosure).

Does this helps?

Re: Error in tfileoutputdelimited.

Anonymous — Tue, 28 Nov 2017 13:12:17 GMT

Hi Sabrina,

I am not trying to write it into different file,i need the entire data in single file.

Thanks,

Padmini.

Re: Error in tfileoutputdelimited.

Anonymous — Tue, 28 Nov 2017 13:15:19 GMT

Hi TRF,

Thanks for the reply, i tried as you mentioned but still the issue persists,please find attached txt file for the same.

First 2 records are in correct as there is no any Arabic data, but in my third record as it contains arabic language its jumping up to next line.

Thanks,

Padmini.

MNT_File_issue.txt