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.
Solved! Go to Solution.
Have you considered the find and replace tool?
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
User | Count |
---|---|
18 | |
16 | |
14 | |
6 | |
5 |