function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shane2017Shane2017 

command line data loader: "com.sforce.async.CSVReader$CSVParseException: Found unescaped quote. A value with quote should be within a quote"

but there are no quotes in my CSV file (UTF-8 encoded)

any advice?? Thanks!
NagendraNagendra (Salesforce Developers) 
Hi Shane,

Sorry for this issue you are encountering.

The double quotes in some column exist without escape character and qualifier.  I was able to reproduce the issue and you can see that in below screenshot.  I have value column Otherstreet as K"en Street. This is when I get the same error. 

When the value is added with escape character and with a qualifier, the file works fine. The value that worked is "K""en Street"

I have also added a screenshot of data loader success result which shows how the value was inserted into Salesforce record.

You can open your CSV file in excel and save it which should take care of adding a qualifier and escape character.
User-added image
Hope this helps.

Kindly mark this as solved if it;s resolved.

Thanks,
Nagendra
Shane2017Shane2017
There are no quotes in my CSV file so there are no quotes to escape.
Shane2017Shane2017
The problem is that I'm getting the error even though there are no quotes in my CSV file.