Escaping in CSV Formatted Files

For example, suppose you have a table with three columns and you want to load the following three fields:

The data value with a comma character that is part of the data is enclosed in double quotes. The double quotes that are part of the data are escaped with a double quote even though the field value is enclosed in double quotes.

"Free trip to A,B ",5.89 ","Special rate ""1.79"" "