Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Capturing special characters

Cherkos12
7 - Meteor

Hi -

i only want to capture the 'wx' and 'ag' from this column. the problem with this column is that some of them have '21' before them and i'm wondering how i can get just 'wx' and 'ag' in a different column without the prefix '21'

 

thanks 

 

Cherkos12_0-1633014832759.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Cherkos12 

 

Here is how you can do it. Two methods formula and regex.

Workflow:

 

atcodedog05_0-1633015215889.png

 

Hope this helps : )

Cherkos12
7 - Meteor

This helped. Thanks

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Cherkos12 

Cheers and have a nice day!

Labels