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 (TheBlogReaders.com) and we can replace from .com to .net using following formula

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

Result: TheBlogReaders.net

SYNTAX:
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 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 5x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply

Your email address will not be published. Required fields are marked *

*