+ Start a Discussion

Apex Data Loader -- Export and Import with Double Quotes

Hi All,

When exporting with Data Loader, I am finding that it does not escape double quotes, which are also used to enclose fields.

Here is a sample output:

"apple","orange","<a href="http://www.google.com">TEST</a>"

This is causing issues when importing into MySQL because of column 3, the HREF tag, which has a double quote inline.

How do I configure Data Loader to use an escape character?

Has anyone else experienced the same issue when importing into MySQL?

Need an account? Sign Up

Have an account? Sign In