How to make two Replace function in one expression

I'm trying to replace two different target in one expression. I'm using Action tool >> Update Raw XML with Formula.

Accepted answers

Hi Adrian, you can do this by wrapping one Replace() function around another, like this:

Replace(Replace([string_field],"Target1","Replacement1"),"Target2","Replacement2")

All comments

MacRo

Hi Adrian, you can do this by wrapping one Replace() function around another, like this:

Replace(Replace([string_field],"Target1","Replacement1"),"Target2","Replacement2")

MatthieuArzel

This is not very eleguant.

I'm new to this game, but isn't there a function (in PHP there's the function strtr) allowing an array where a key will be replace by a corresponding value ?

This solution work for 2 or 3 nested replace. I have 12 replace to do in order to solve a baldy formated month problem.

MarqueeCrew

@MacRo's advice is the way that I typically perform these nested replacements. However, you can use a FIND REPLACE tool and cause: Mark Frisch to become Marquee Crew if the FIND REPLACE tool reads a source that converts Mark to Marquee and Frisch to Crew.

Please take a look at the attached example workflow.

Cheers,

Mark

Multiple Replacements.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703