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
Solved! Go to Solution.
@ck2024
find the workflow attached
mark done if solved.
@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.