Replacing non-readable characters with a readable equivalent?

[ck2024]

Hey 

I have to update an extract of data that has multiple non-readable characters within.  I've come up with the nearest equivalent, but is there a way to replace the contents of Field 1 = Bermúdez Díez 

how would I get it to read down the list of the columns in Character Column and replace the matches with the contents of Replace column so that the above example would become MerAodez DAez - there are some examples where there are 5 matches of characters that need replaceing

Character Replacement
ß b
ü u
ń n
’ '
à A
ç c
ö o
ł l
ż z

Thank you

[Raj · Accepted solution]

@ck2024 
find the workflow attached
mark done if solved.

[griffinwelsh · Accepted solution]

@ck2024 The way to do perform this task generally is to use the find and replace tool, but it doesn't seem to work with your special characters. The solution is to use regex replace to perform each replacement. Here is an iterative macro solution that allows you to do that with similar UI to the find and replace tool.