Replacing Special Char in a name

[Saagar]

Hi,

I am a new user. I want to replace characters in the name field 

for example 

Frédéric Passy changed to Fracdacric Passy

How can I do this for the entire column 

Thanks

Saagar

[TheOC]

Hi @Saagar 

This can be done with two tools:
Data Cleansing to remove symbols (©)
Formula to change accents back to their base letters (Ã)

Please find attached.

Cheers,
TheOC

[Qiu]

@Saagar 
I would suggest to use a Find and Replace Tool.

And a manually maitenaned Dictionary for the replacement.

[atcodedog05 · Accepted solution]

Hi @Saagar 

You can use the formula tool replace function like below.

Hope this helps : )

[atcodedog05]

Happy to help : ) @Saagar 

Cheers and have a nice day!

[Saagar]

Thank you this helped 

Further, if I need to see which country has the maximum names should i use a summarize tool and group by country and count distinct on names?

[Saagar]

I don't want to count names which are repeated 

[atcodedog05 · Accepted solution]

Hi @Saagar 

You are correct you would need to do like below

Hope this helps : )

[atcodedog05]

Happy to help 🙂 @Saagar 

Cheers and have a nice day!