Change special characters into "Normal" characters

Question

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")

Raj · Answer

Great ..!

markcurry · Answer

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.

Luke_C · Answer

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

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