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

RegEx Help Please!

ALT_2358
9 - Comet

Hi, 

 

I need to be able to split out a couple of parts from some text and am really struggling with the RegEx coding (this is my first time). I'd really appreciate any help.

 

Here's an example string of text:

 

\\myteams.XXX.com@SSL\DavWWWRoot\sites\TaxReporting2016\POLAND\2020\Q1\PL04 Q1 2020 RQ - 2883.xlsm|Data$

 

I need to extract the year and the quarter (highlighted in bold). These are always present within the string as "\YYYY\QX". I want to ignore any other instances of a year or quarter. 

 

Thanks in advance!

 

 

2 REPLIES 2

Hi @ALT_2358 

 

Please check this out. Cheers!

 

christine_assaad_0-1595522763245.png

 

ALT_2358
9 - Comet

Wow, that was so fast and it works perfectly - thank you!!!

Labels