RegEx Help Please!

[ALT_2358]

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!

[christine_assaad · Accepted solution]

Hi @ALT_2358 

Please check this out. Cheers!

[ALT_2358]

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