cancel
Showing results for 
Search instead for 
Did you mean: 

How do you clean-up Special Characters?

deborah_basile
Enthusiast

Hello,

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?

1 ACCEPTED SOLUTION

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!!

Kind regards,

Debbie Basile

Data Integrity Specialist

LenelS2

View solution in original post

3 REPLIES 3

JonG_Validity
Validity Team Member
Validity Team Member

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.

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(${FirstName},"ā","a"),"à","a"),"á","a"),"â","a"),"ã","a"),"ä","a"),"å","a"),"è","e"),"é","e"),"ê","e"),"ë","e"),"ç","c"),"ì","i"),"í","i"),"î","i"),"ï","i"),"ð","th"),"ñ","n"),"ò","o"),"ó","o"),"ô","o"),"õ","o"),"ö","o"),"ù","u"),"ú","u"),"û","u"),"ü","u"),"ý","y"),"ÿ","y"),"š","s"),"Ž","z")

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.


Regards,

Jonathan Greenip
Customer Success Manager

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!!

Kind regards,

Debbie Basile

Data Integrity Specialist

LenelS2

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


Regards,

Jonathan Greenip
Customer Success Manager