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!

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
11 - Bolide

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!