Change special characters into "Normal" characters

[erikschaap12]

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

[Luke_C]

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

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

[markcurry]

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]

Great ..!