Problem with using tFileInputDelimited for csv file

[Anonymous]

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 · Accepted solution]

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]

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