cancel
Showing results for 
Search instead for 
Did you mean: 

Remove a non-alpha character from the Title field

CRMSarah
Frequent Contributor

Hi everyone - easy question here for someone. 

We have an external tool that adds '^' to a Contact's title. For instance, the contact's title would be '^Accountant^'. I'm looking to run a cleanup job every night that would remove the Caret Notation mark. Any recommendations on how to go about this? 

Thank you! 

Thanks,
Sarah Orens | Salesforce Administrator
Twitter: @SarahOrens
Trailblazer Profile: https://trailblazer.me/id/crmsarah1
1 ACCEPTED SOLUTION

CRMSarah
Frequent Contributor

Disregard! I figured it out! 

StringReplace(${Title}, "^", "")

Thanks,
Sarah Orens | Salesforce Administrator
Twitter: @SarahOrens
Trailblazer Profile: https://trailblazer.me/id/crmsarah1

View solution in original post

3 REPLIES 3

CRMSarah
Frequent Contributor

Disregard! I figured it out! 

StringReplace(${Title}, "^", "")

Thanks,
Sarah Orens | Salesforce Administrator
Twitter: @SarahOrens
Trailblazer Profile: https://trailblazer.me/id/crmsarah1

@CRMSarah don't you just love when you answer your own question 😉 Thanks for sharing the answer! I will mark it as an Accepted Solution for you. 

 

Scooch
Senior Community Manager
Validity - Boston

CRMSarah
Frequent Contributor

I am far too competitive for communities. I only post because that really puts my googling into high gear. I know I'll solve it the minute I ask for help from the community. 🤣

Thanks, Scooch! 

Thanks,
Sarah Orens | Salesforce Administrator
Twitter: @SarahOrens
Trailblazer Profile: https://trailblazer.me/id/crmsarah1