Remove special characters from a list of names

[MH5]

Hello, 

I'm have a list of names that contains special characters. I want to transforme for example "é" to "e", "è" to "e" and "à" to "a". The list is actualy long (around 200 chara

[wdavis]

Hi @MH5 

Do you have a list containing all of these characters?

If you do, you could use the Find and Replace tool to search for those characters within the names and replace them with the character you would like.

Kind Regards

Will

[TonyA · Accepted solution]

You can start with the DecomposeUnicodeForMatch() function under the string functions in the formula (and other) tools. If there are other characters you need to convert, you can use Find/Replace as @wdavis suggested. I attached a small example

[AlteryxUserFL]

This should work: regex_replace([test],"[^\sa-zA-Z]",'')

[TonyA]

Hi @MH5,

If one or more of these responses answer your question, please mark them as solutions so everyone knows this question was resolved. Thanks!

[MH5]

Thanks @TonyA.

It's simple & it worked