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
hramanihramani 

Need to build a formula for TRIM in Process builder

I have a requirement where I have a field named 'Product__c' from where I need to pick the characters starting from ';' to the end of line and populate that on another field named 'Latest_Product__c'
I need to do it in a Salesforce formula on a Process builder.
e.g. 
Product__c = Chair;Table
I need to write a formula to pick only 'Table'

Product__c = Chair;Table;Sofa
I need to write a formula to pick only 'Sofa'

Can someone help please.
ShirishaShirisha (Salesforce Developers) 
Hi,

Greetings!

You can achieve this by using begins() function for the below example:

Product__c = Chair;Table

Example syntax:(BEGINS(Product__c, ";"))

Howevever,I don't think this works with the second scenario so you need to use the apex code to achieve this.

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri