Q. How to differentiate commas within field while uploading using Data Loader ?
Ans: Data Loader cannot differentiate this implicitly because there is no logical path to follow. In this case Data Loader CSV file for import will contain commas for any of the field content, you will have to enclose the contents within double quotation marks ” “. Data Loader will be able to find this.For example :
If you are creating the import CSV in Excel, the quotation marks will be inserted automatically by Excel whenever a comma is detected in any cell – Saving the CSV in Excel and opening the same in Notepad reveals the enclosing quotation marks for cells containing commas.