File Delimited: Delimiter Conflict issue

[Anonymous]

Hello,
when i import a file in metadata File Delimited, i get a conflict with data content and file delimiter.
The file is a CSV file with delimiter as comma (,). This is kind of fixed and cannot be changed due to other reasons.
The file also contains data such as "1,00,000.00".
So, when i import the file, it breaks it into three column.
Column 1 : "1
Column 2 : 00
Column 3 : 000.00"
How do i avoid this?

[Anonymous]

While creating metadata, you can opt for field enclosure as "" CSV options. this ensures that it reads all the data between double quotes.
Pl check the documentation for https://help.talend.com/search/all?query=tFileInputDelimited&content-lang=en
Vaibhav

[Anonymous]

I tried it. But it is not working. Can you please suggest any thing else which i can try.
I am using Metadata: File Delimited.
Please let me know if you need any other info.

[Anonymous]

It works, pl check the screenshot, you might have missed something...
Following was input in csv file
id, amount
"1","1,00,000.00"

Vaibhav