Error in tfileoutputdelimited.

[Anonymous]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina

[TRF]

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?

[Anonymous]

Hi Sabrina,

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

Thanks,

Padmini. 

[Anonymous]

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