Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

String Conditions

AS
8 - Asteroid

Hi Alteryx Experts,

 

I need help in string condition. Please find below the table of conditions and Alteryx Result-

 

NameAlteryx Result
West Card: ABCD UK; DHDR RSD7ABCD UK
WC - EFDD US- DDFCEFDD US
WC- 123123242 India/ YELLOW1231123242 India
West Card- 3e53w Russia : DSES3e53w Russia
West Card- 3ererv3AD Name ;DDFC 3ererv3AD Name

 

Basically West Card-, WC : , WC: would be the keyword and I have to pick 2 words after that keyword. I'll insert the if else condition for that but I'm confused how to select 2 words after that. Can someone help.

Thanks in advance

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645774505151.png

 

Hope this helps : )

 

sparksun
9 - Comet

My solution:

sparksun_1-1645780097600.png

 

 

sparksun_0-1645780074839.png

 

AS
8 - Asteroid

Hi This solution solving 80% of my issue. I'm not good in Regex so - can you also cover certain condition in this regex.

Thanks in advance

 

Name 
West Card ABC.com/US - 1x 16 
West Card- Jio 
WC- We DC - do not hold-new  
WC-Software.com - 20 Street 
West Card - PC - 01/30 - 02/28/2022 

 

This bold text needs to capture

atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

It would be super tough to incorporate this since it doesn't follow any pattern the code might break like below.

 

atcodedog05_0-1645783531928.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @AS 

Cheers and have a nice day!