Vahidkhan Lodi
How to handle comma within a field while uploading using Data Loader?

In a Data Loader .CSV, if there is a comma in field content, you will have to enclose the contents within double quotation marks: ” “.

By Vahidkhan Lodi in Salesforce on Jan 24 2023
  • Tuhin Paul
    Feb, 2023 22

    Yes, you are correct. To handle commas within a field while uploading using Data Loader, you need to enclose the field value within double quotation marks. This ensures that the comma is not interpreted as a field delimiter by the data loader.

    For example, if you have a field called “Description” and the description includes a comma, you would format it like this:

    “Product A, with extra features”,123,4.56

    Here, the description “Product A, with extra features” is enclosed within double quotes to ensure that the comma within the field value is not interpreted as a field delimiter by the Data Loader.

    Similarly, if the field value itself includes double quotes, you need to enclose the entire field value within double quotes and use an escape character (usually a backslash) to escape the double quotes within the field value.

    For example:

    “This is a “quoted” field value”, 123, 4.56

    Here, the field value “This is a “quoted” field value” is enclosed within double quotes and the inner double quotes are escaped using a backslash.

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS