function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lil_rangerlil_ranger 

Substitute function help

AND(SUBSTITUTE(Assumptions__c , "~", "<br />"),
SUBSTITUTE(Assumptions__c, "^", "<li>"))

 Is it possible to have more than 1 substitute function in a field update?  I can get one of them to update, but not both. 

Navatar_DbSupNavatar_DbSup

Hi,


Try the below formula:
if( CONTAINS(Assumptions__c , '~') , SUBSTITUTE(Assumptions__c, "~", "<br />"),
if(CONTAINS(Assumptions__c, '^') , SUBSTITUTE(Assumptions__c, "^", "<li>")," "))

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 
lil_rangerlil_ranger

Hi,

 

I tried the update.  It did the <br /> as intended, but it wouldn't pick up the second substitiution for the "^".