Handling Quotes in CSV files

If data in your comma delimited text file has a value such as "$5,600" where (,) is part of the data value and it must not be considered a delimiter, check the Quotes Handling On property in the Text Schema > Advanced Properties.

By checking this property, any data value with (,) encapsulated in double quotes will not be considered as a delimiter.