We have hundreds of international accounts and contacts that use special characters that don't always convert into a readable format. How can I use Validity to find special characters and then possibly modify them?
Thank you very much Jonathan. That formula looks a bit overwhelming, but if that is what it takes to get rid of unwanted special characters, I will give it a try.
By the way, I have attended several of your Validity Demand Tools webinars and find them very helpful and easy to follow - Thank You!!
Hi @deborah_basile, I think we can assist with this - Below I've included a Modify formula that is meant to idenitfy international/accented characters and replace them with the English equivalent in Salesforce. You can copy this formula and paste it into the Modify Formula Editor & change the field being evaluated - just change update the section that says ${FirstName} with the syntax for the field you'd like to evaluate.
This awesome formula was presented in one of @AnthonyValidity's incredible training sessions! All the formulas from that session can be found here. If this is not what you meant by international characters, please let me know and I can try to think of something else.
Thank you very much Jonathan. That formula looks a bit overwhelming, but if that is what it takes to get rid of unwanted special characters, I will give it a try.
By the way, I have attended several of your Validity Demand Tools webinars and find them very helpful and easy to follow - Thank You!!
@deborah_basile Just let us know if you run into issues with it! And we love to hear your feedback regarding the webinars. Make sure to keep up with our calendar here, we have some brand new sessions coming up in April!
