Replace multiple characters in multiple fields

[BautistaC888]

Hello,

I want to replace multiple characters in multiples fields.

I used a multi-field formula with the following expression:

Replace([_CurrentField_], "Ð", "Ñ") and Replace([_CurrentField_], "¬", "°") and Replace([_CurrentField_], "Ô", "á") and Replace([_CurrentField_], "¢", " ") and Replace([_CurrentField_], "Ë", "Ó") and Replace([_CurrentField_], "À", "") and Replace([_CurrentField_], "³", "ü") and Replace([_CurrentField_], "¨", "ú") and Replace([_CurrentField_], ";", "") and Replace([_CurrentField_], "Ê", "E") and Replace([_CurrentField_], "Þ", "é") and Replace([_CurrentField_], "÷", "ö") and Replace([_CurrentField_], "´", "í") and Replace([_CurrentField_], "½", "1/2") and Replace([_CurrentField_], "î", "í") and Replace([_CurrentField_], "'", "") and Replace([_CurrentField_], "î", "í") and Replace([_CurrentField_], "#", "N.") and Replace([_CurrentField_], "°", "") and Replace([_CurrentField_], "´", "")

But the formula replaced all the data with "0":

I want to know a way to replace multiple characters in multiple field is possible with multi-field formula or a Regex.

Thank you.

[MatthewBr]

Have you considered the find and replace tool? 

[MatthewBr]

@BautistaC888 

[KarolinaRoza · Accepted solution]

hi @BautistaC888 

Your formula is not working correctly, as you can not include several 'and' in the formula. It will work if you rewrite it to:

Replace(Replace([_CurrentField_],"¬","°"), "Ð", "Ñ") 

but as long as you have a lot of values to replace it is not efficient.

I also reccomed you to use Find/Replace tool.

See workflow attached.

Let me know in case you need more help.

Karolina

[binay2448]

Hi @BautistaC888 ,

You can use find and replace tool, find attached workflow for help