Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
8 - Asteroid

Great ..!

Labels