Hi, I'm trying to extract the MMM yyyy value from a string where it can have multiple variations of formatting. Below are examples of the different variations I'm seeing and the desired output:
| String value | Output |
| 252.204-7000 Disclosure Of Information (Oct 2016) | Oct 2016 |
| 252.204-7003 Control Of Government Personnel Work Product Apr 1992 | Apr 1992 |
| ____ (14)(I) 52.219-6, Notice Of Total Small Business Set-aside (Nov 2020) (15 U.S.C. 644). | Nov 2020 |
| X (58) 52.232-33, Payment By Electronic Funds Transfer—System For Award Management Oct 2018 | Oct 2018 |
The top 2 only differ where MMM yyyy is either in () or not. I'm using \((.*?)\) to capture Oct 2016 but it will fail on the string without parenthesis. The bottom 2 won't work either since there are 1 or 2 sets of parenthesis at the beginning of the string value so I'm lost on how to do this.
Should I be using a Regex tool for this work or am I better off writing a formula to what I need? Any help is greatly appreciated!
