Replace two string with each other

Question

My data looks like this:

String##123456-ID##261111126-ID

And I want to replace every 6 with 2 and every 2 with 6 so the output would look like this

and I can't use a temporary word because I don't know what will be included in the string in the future

String##163452-ID##621111162-ID

atcodedog05 · Accepted Answer

Hi @coder2022

Let's make the temporary word more unique so that it doesn't get replaced by accident. I am creating temp words @~two~@ which have less possibility of occurring in that way.

Edit: further optimizing it

Workflow:

Hope this helps : )

Jonathan-Sherman · Accepted Answer

Hi @coder2022,

I would go down the route of replacing the 6 with a pipe, converting the 2 to a 6 and then reverting the pipe into a 2.

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan