Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Remove special characters from a list of names

MH5
6 - Meteoroid

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

5 REPLIES 5
wdavis
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

TonyA
Alteryx Alumni (Retired)

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
11 - Bolide

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

TonyA
Alteryx Alumni (Retired)

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
6 - Meteoroid

Thanks @TonyA.

It's simple & it worked

Labels