topic Remove a non-alpha character from the Title field in DemandTools

Remove a non-alpha character from the Title field

CRMSarah — Fri, 17 Mar 2023 18:05:05 GMT

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!

Re: Remove a non-alpha character from the Title field

CRMSarah — Fri, 17 Mar 2023 18:22:35 GMT

Disregard! I figured it out!

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

Re: Remove a non-alpha character from the Title field

Anonymous — Fri, 17 Mar 2023 18:35:08 GMT

@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.

Re: Remove a non-alpha character from the Title field

CRMSarah — Fri, 17 Mar 2023 18:37:16 GMT

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!