function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Dave The RaveDave 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"


AnudeepAnudeep (Salesforce Developers) 
As per the documentation, If commas aren’t appropriate for your locale, you can use a tab or other delimiter. You need to specify your delimiter in Data Loader Settings (Settings | Settings).

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!