Replace Char Issue

Hi,

Facing an Issue with one of my formulas

Input given =1234567890

Formula Used = ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar(ReplaceChar([ID],"1","0"), "2","9"),"3","8"),"4","7"),"5","6"),"6","5"),"7","4"),"8","3"),"9","2"),"0","1")

Output =1234554321

Desired Output =0987654321

Please help,

Thanks in advance.

Regex

Accepted answers

grazitti_sapna

Hi @gauravnegi2 , in case of multiple columns rather than applying a formula tool for every column I will suggest you to transpose the table into a single column then apply the find and replace tool at the end you can again reverse the result using a cross tab tool, if this helps?

Thanks.

All comments

ImadZidan

Hello @gauravnegi2 ,

This is a reverse function.

Attached is an idea.

Hope it helps

Rev.yxmd

philipmannering

Perhaps this might work. See attached.

otherwise convert the field to string and use the find and replace tool would also work.

replacechars.yxmd

gauravnegi2

Hi @ImadZidan @PhilipMannering ,

Actually this a sample data the use-case is bit different

For example:- I have a string "UA12GF43" and the Output i want is "UA09GF78" .

vizAlter

@gauravnegi2 — And, if you just want to reverse the order of any value (String/Numeric), then refer to the attached workflow.

Input given =1234567890

Desired Output =0987654321

Input given ="AB 12CD"

Desired Output ="DC21 BA"

If this post assists in resolving the question, please mark it "Like", or "Solved" if it resolves the question. This will help other users find the same answer/resolution. Thank you.