HI,
I have a string- AB*WX-CD*YZ-EF*YZ
I want to replace "WX" with "YZ" and "YZ" with "WX". Is there any way to flip the characters within the string?
The string length can vary. So I think "Text To Column" option won't work.
Thanks
I mocked up a workflow let me know what you think? Is it those two characters that need flipping?
Thanks for your reply.
Well, its not the characters the need flipping. Think of "WX" as "Yes" and "YZ" as "No". I want to change Yes to No and No to Yes in the entire string.
