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.
Are you looking for "Split output in several files" option in advanced settings of tfileoutputdelimited component?
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?
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.