[SalesForce] How to split a string by comma and single quotation mark in apex

Following is a string:

 'First Name','Last Name','Account Name','Email','Title','Description'

and I want it to split with ",'" (comma and single quotation mark).

Best Answer

Try with this

First remove all single quotes and then split by comma

String str = '\'First Name\',\'Last Name\',\'Account Name\',\'Email\',\'Title\',\'Description\'';
System.debug('===str==='+str);
for(String strFinal: str.replace('\'', '').split(','))
{
    System.debug('===Final val==='+strFinal);
}

Another option

If we are sure single quotes will be start and end of string then we can remove using string method

for(String strFinal: str.split(','))
{
    System.debug('===Final val==='+strFinal.removeStart('\'').removeEnd('\''));
}

Related Solutions

[SalesForce] problem replacing and splitting string

Split in Apex is very similar to Java string split.

the pattern you pass to the split method is not a direct match, its a REGEX pattern. so the pipe symbol | is considered as a Regex input and it splits the string into individual characters.

You can use the below code to get thru this

newString.split('\\|')

here's some other discussions around the same topic

https://stackoverflow.com/questions/6978901/splitting-a-string-using

and a blog post from Lacey on the same topic

[SalesForce] Include single quotation mark in string

This way it works:

trigger SingleQuote on Account (after insert) {
   Trigger.New[0].addError(' Please ask your Salesforce Administrator to add a target record, for the month & year of your Opportunity\'s close date');
}

AND

Best Answer

Another option

Related Solutions

[SalesForce] problem replacing and splitting string

[SalesForce] Include single quotation mark in string

Related Topic