RegEx Date Parse with multiple patterns

[182129]

We have a lot of manual processes around parsing dates out of data when multiple sources use different formatting and sometimes no dates at all. It also complicates matters because some of the data includes numeric values that have nothing to do with dates.

Below is a small sample of data and Period is the desired outcome of the parse. I've attached a larger sample set as well. 

FYI we're on Designer 2020.3 so please post configurations in lieu of workflows.

StringText		Period desired
CCR1083AB0BBD194E529EA1		Null
Reclass to OCI 0523		5/1/2023
CCR19126C641BF141ACB98A		Null
SEP 22 LONG|SCHEDULED|CP|	9/1/2023
IC ACCRUAL CO 1222		12/1/2022
ReclassOCI0323		3/1/2023
1122MotelsTranspReclass		11/1/2022
FSCPreclassOCI1022Motels		10/1/2022
MotelsReclass1122		11/1/2022
1392390		Null
1409492		Null
08/22 LMI LONG SCHEDULED		8/1/2022
09/22 LMI TRANSPORT SCHED		9/1/2022

[BS_THE_ANALYST · Accepted solution]

@182129 in my opinion, this approach will be the best. You basically supply a list of all the incoming date types:

Add to the formula tool. Whatever date formats it's coming in as - see this link for the date time specifiers: https://help.alteryx.com/20231/designer/datetime-functions 

Rest of the workflow will do the 'RegEx' part:

 

[182129]

That actually works, although it seems counterintuitive to have to keep increasing the dates in perpetuity. I did add more dates as we have to actually go back through 2020 and used today() for an end date.

It also helped dramatically for me to be able to set up additional potential date formats, as that was just a sample of the much larger data. THANK YOU