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.
Any input greatly appreciated.
5 answers
You can now achieve this using an Apex Action
https://unofficialsf.com/stringnormaliser-apex-action/:-)