One Star

tFileInputDelimited - import from csv files with ; in text fields

Hi,
I am trying to import some data with tFileInputDelimited from a csv file. As fieldseparator I`m working with ";". Some text fields in the csv file includes  an ";" (with normal text enclosure ") but talend parse this as an additional row. The documentation talks about a parameter "Split row before field"  but I can`t find them in advanced settings. 
Any suggestions?
TOS-Version: 6.2.0
Regards,
Thomas
4 REPLIES
One Star

Re: tFileInputDelimited - import from csv files with ; in text fields

Hi,
Check the advanced settings of tFileInputDelimited configuration.
Regards,
TRF
One Star

Re: tFileInputDelimited - import from csv files with ; in text fields

Hi TRF,
thanks, playing around with the csv options brought the solution. 
I found out a trick with tFileInputDelimited: You have one more option (called "Split row before field") if you first put the file into Meta Data --> File delimited and then create an input with this in the job. First I created only an Input with "raw" tFileInputDelimited and did not found the option which is described in the reference guide...
Regards,
Thomas
One Star

Re: tFileInputDelimited - import from csv files with ; in text fields

Can you please try the same scenarion using TOS 6.1.1?
Want to know if the problem is due to TOS 6.2 or if it is a normal behavior.
Four Stars

Re: tFileInputDelimited - import from csv files with ; in text fields

Hi All,
Can you please provide me a solution for my scenario.
My source file data looks like below. It contains 3 fields separated by | (pipe) delimiter. All fields are enclosed by doubt quotes "". But the issue is one of the fields data contains double quotes as a data as well. 
"From"|"Msg: " Hi, how are you"  Message ended"|"To"
Can you tell me how to handle this.
Thanks,
Jayachandra