Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Flipping Characters

Aria_S
7 - Meteor

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 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

I mocked up a workflow let me know what you think? Is it those two characters that need flipping?

Aria_S
7 - Meteor

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.

Labels