+ Start a Discussion
salesforce@14salesforce@14 

How to save the records with commas(,) from csv file to salesforce.

Hi,

  I try to insert csv file with column last name and email and my last name column contains the value as ABC, Inc. .When i try to insert that csv file it showing an error as Insert failed. First exception on row 0; first error: INVALID_EMAIL_ADDRESS, Email: invalid email address: Inc.": [Email__c].

What is happening here is after the commas(,) it taking as email address thats y this error is coming.
So how to keep the last name as last name even it contains (,).


Thanks in advance.
elpis4466elpis4466
I think the problem is how you parse your data from your csv. Use the code in this link to parse your data . https://developer.salesforce.com/page/Code_Samples