Activity Forums Salesforce® Discussions How to handle comma within a field while uploading using Salesforce Data Loader?

  • How to handle comma within a field while uploading using Salesforce Data Loader?

     Divya updated 3 years ago 4 Members · 4 Posts
  • Manpreet

    Member
    April 19, 2017 at 1:36 pm

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

  • Suraj

    Member
    April 19, 2017 at 2:10 pm

    Hi Manpreet,

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

  • Avnish Yadav

    Member
    September 30, 2018 at 3:25 am

    Hello,

    A properly formatted CSV can contain commas in its field values and can be used to import data.

    Thanks.

  • Divya

    Member
    November 12, 2018 at 10:28 am

    Hi Manpreet,

    To do this, you have to surround each of your data columns with quotes.  So if I wanted to insert an Account with the Name of "Comma, Name" I would use:

    "Name", "Industry"
    "Account, Name", "Electronics"

Viewing 1 - 4 of 4 posts

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos