You need to sign in to do that
Don't have an account?
Dave The Rave
add " (speech marks) to a text field using DML statement
add " (speech marks) to a text field using DML statement
I am importing data into SF, but have a comma in some text strings, when you create a CSV the comma is also a delimiter, so I have fields without a header in my CSV file.
Using DML code, I would like to amend several text fields, so:
text__c = I am, a text
" + text__c + " (Concatenate) for example = "I am, a text"
Thanks,
Dave
I am importing data into SF, but have a comma in some text strings, when you create a CSV the comma is also a delimiter, so I have fields without a header in my CSV file.
Using DML code, I would like to amend several text fields, so:
text__c = I am, a text
" + text__c + " (Concatenate) for example = "I am, a text"
Thanks,
Dave
If adjusting the Data Loader Settings does not help, I recommend taking a look at this post. Also this one
Let me know if this helps, if it does, please close the query by marking it as solved. It may help others in the community. Thank You!