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.

Change special characters into "Normal" characters

Erik_Schaap1
6 - Meteoroid

Working with Eastern European data I often encounter these special characters (ex: Brașov) that I want to get rid of.

Problem is that I do not want to simply remove the characters but replace them with the equivalent (Brașov must be changed in Brasov).

A simple way to do it is using a formula: DecomposeUnicodeForMatch. It will do the job. The complete formula is:

 

TitleCase(DecomposeUnicodeForMatch("Brașov")

 

3 REPLIES 3
Luke_C
17 - Castor

Agreed, it's a super helpful function. Here's more info on it: 

https://help.alteryx.com/20223/designer/string-functions#decomposeunicodeformatch

 

markcurry
12 - Quasar

You could also look at ...

ConvertToCodePage("Brașov",20127)

 

It will do the same job but it keeps the characters in the same case, you don't need the TitleCase function.

Raj
13 - Pulsar

Great ..!

Labels