Skip to main content

This approach solved my problem except I'm not having luck adding in more SUBSTITUTES.   

 

SUBSTITUTE({!$Record.FIELD__c} ,  LEFT( {!$Record.FIELD__c}  ,  FIND(".",  {!$Record.FIELD__c} )), "")

&SUBSTITUTE( {!$Record.FIELD__c}  ,  LEFT( {!$Record.FIELD__c}  ,  FIND("-",  {!$Record.FIELD__c} )), "")

&SUBSTITUTE( {!$Record.FIELD__c}  ,  LEFT( {!$Record.FIELD__c}  ,  FIND("/",  {!$Record.FIELD__c} )), "")

 

 I'm looking for a more efficient method so that I could just check to see if the field is A-Z and replace the special character.

 

@Bob Moalli

 

Any input greatly appreciated. 

5 answers
0/9000