+ Start a Discussion
srikanth challasrikanth challa 

How to handle double quotes " " using dataloader

Hi Guys when I upsert records using data loader which consists of double quotes Phone__c="1111111111" the field is populating without ignoring the doublequotes i.e User-added image   Is it any way to ignore double quotes and load only the value which is in between the double quotes?
Donald BlayDonald Blay
I don't think there's any way to make the data loader ignore the double quotes. You'll need to normalize the data before you import.  
For example in Excel you could select the Phone column and then use the replace function to replace the double quote wiht a empty string. You might need to do something similar if there are other unwanted characters.