Exception handling

[Aleksander_Gorski]

Hello guys,

I am thinking how to manage with several names in different languages. 

I have got a column with names of people from different countries, now I have a several guys from Germany, some of them have umlauts in theirs names, then I create a next column with emails and I want to change umlauts to english description for example "ä → ae" .

But there was also some names with an apostrophe sign in and I think there also there will be added in future some other names with other diacritic signs. First think was to create an if statement with some array of key-values order and set up regex in formula to handled it. 

So what do you think, how to manage this task? 

[ivoller]

Find Replace Tool?

[MarqueeCrew · Accepted solution]

@Aleksander_Gorski,

Here's how I would do it:

1. Filter names out with those character sets (not A-Z).
2. Tokenize them into their individual letters.
3. Replace them from a table of conversions that you generate and apply with the FIND REPLACE as @ivoller suggests.  You use this tool to keep the letter order.
4. Concatenate the string back together
5. Union your name records
6. Enjoy life

Cheers,

Mark