topic Re: Problem with using tFileInputDelimited for csv file in Talend Studio

Problem with using tFileInputDelimited for csv file

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

Hi,

I'm using TDI open studio where I'm trying to read csv file from local machine using tFileInputDelimited.

Below is the screenshot of the csv :

In properties of tFileInputDelimited:

Output for field separator = ";"

Output for field separator = ","

2 Problems:

1.Why each value is enclosed in double quote (")

2. Field separator = "," just working fine, but what in case of value like "Fife, WA" in column NAME ?

So, what could be done in order to read data from csv file in an efficient way ?

Thanks !

TRF — Mon, 12 Jun 2017 13:39:25 GMT

Field separator must not appear in the content, that's the problem you have, field separator is "," and it appears in content (LWNAME = fife,WA).

You must change the separator in the source file, or enclose field values between quotation marks ("fife,WA") and tick "CSV options" field.

Anonymous — Mon, 12 Jun 2017 13:45:32 GMT

Checking CSV options worked. I tried this earlier but don't know why it didn't get to work, might be missed something.
Thanks @TRF