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

tFileInputDelimited - import from csv files with ; in text fields

Anonymous — Sat, 16 Nov 2024 10:29:20 GMT

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

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

TRF — Mon, 25 Jul 2016 09:46:43 GMT

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

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

Anonymous — Mon, 25 Jul 2016 12:36:35 GMT

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

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

TRF — Mon, 25 Jul 2016 14:30:02 GMT

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.

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

Anonymous — Fri, 09 Dec 2016 13:19:47 GMT

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