community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Remove special characters from a list of names

Atom

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

Alteryx
Alteryx

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

Alteryx
Alteryx

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

Asteroid

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

Alteryx
Alteryx

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!

Atom

Thanks @TonyA.

It's simple & it worked

Labels