How to Replace the values Using Salesforce Formula field

We can easyily remove the last character from a string by using the SUBSTITUTE() in the Formula.
For Instance, If value__c is a string ( and we can replace from .com to .net using following formula

SUBSTITUTE(value__c, ‘.com’, ‘.net’)


SUBSTITUTE(text, old_text, new_text)
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string

Written by 

3x Salesforce MVP | Platform Champion | 18x Salesforce Certified | MuleSoft Certified | 8x Trailhead Ranger | TechForce Services | Sydney | Australia

Leave a Reply

Your email address will not be published.