String Conditions

[AS]

Hi Alteryx Experts,

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

Name	Alteryx Result
West Card: ABCD UK; DHDR RSD7	ABCD UK
WC - EFDD US- DDFC	EFDD US
WC- 123123242 India/ YELLOW	1231123242 India
West Card- 3e53w Russia : DSES	3e53w 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

[atcodedog05]

Hi @AS 

Here is how you can do it.

Workflow:

Hope this helps : )

[sparksun]

My solution:

[AS]

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 · Accepted solution]

Hi @AS 

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

Hope this helps : )

[atcodedog05]

Happy to help : ) @AS 

Cheers and have a nice day!