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!
Solved! Go to Solution.
Wow, that was so fast and it works perfectly - thank you!!!