How to extract part of the string based based on a list of values?

Hi everyone,
I am new to Alteryx and unable to figure this out

my data has the following line items for example:

expense Apr 21 - Jun 21

SO Jul 22 - Sep 22 expense

basically, expenses for the quarter where the period is mentioned in the description at varying character places.

i wish to extract the period mentioned which can start with any of the 12 months
I have defined a list of Months (Jan, Feb, Mar, .. Dec) but:

1. How do i do it?
2. If the list is used, while trying to search the month in the text, both start and end month of the quarter will be present in the list, how would that impact the output?

Transformation

Accepted answers

Christina_H

If the format of the dates is consistent you could use this:

.*(\u{3}\s\d{2}\s-\s\u{3}\s\d{2}).*

All comments

ShankerV

@pkmc

If I understand your requirement, you need the output as Jul 22 - Sep 22

Many thanks

Shanker V

ShankerV

Hi @pkmc

Proposing a simple solution

Many thanks

Shanker V

ShankerV

Hi @pkmc

Step 1: Input

Step 2: Regex tool

Output after run:

Many thanks

Shanker V

ShankerV

Hi @pkmc

Kindly accept my solution if it resolved your show stopper.

Many thanks

Shanker V

pkmc

Hi thank you for your response!
Yes, i wish to extract the period

While i didn't understand the expression
looking at the output, it seems it is giving me the first 15 characters after the first whitespace

but the placement is not uniform across

so it could be as the following and keep on changing

entertainment expense Apr 21 - Jun 21

India high power SO Jul 22 - Sep 22 expense

ShankerV

@pkmc

I posted the output for the input shared, if the huge dataset is not similar; please share more inputs from the huge dataset covering multiple scenarios.