Replace two string with each other

[coder2022]

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 solution]

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 solution]

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

[Qiu]

@coder2022 
You metioned that you dont want to use a temporary word so we have to make sure the Find and Replace happening only once.

So how about we just use Find and Replace?

There will be an input file, which is also easy for future maintenance and scaling.

[atcodedog05]

Happy to help : ) @coder2022 

Happy new year to you and your close ones : ) May it be filled with happiness and prosperity =D