Gelöst! Gehe zu Lösung.
Hi Adrian, you can do this by wrapping one Replace() function around another, like this:
Replace(Replace([string_field],"Target1","Replacement1"),"Target2","Replacement2")
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.
@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
The replacement tool is really handy when you need to search and replace in your fields values. I love to do this.
The thing is i'm using a dyanmic rename action in order to clean my columns name (before using a big transposition action).
Dynamic rename doesn't allow me to input the search and replace action flow.
I was looking for a solution using only formula fonctions inside dyanmic rename.
DateTimeParse(
REGEX_Replace(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
[_CURRENTFIELD_]
, "janv", "01")
, "fév", "02")
, "mars", "03")
, "avr", "04")
, "mai", "05")
, "juin", "06")
, "juil", "07")
, "août", "08")
, "sept", "09")
, "oct", "10")
, "nov", "11")
, "déc", "12")
, "^Diary Time (\d+)\s(\d+).?\s(\d+)$", "\3-\2-\1"),
"%Y-%m-%d")
If you have any advise for something more clean, I am very interested.