How to parse (remove) the date from string, with the format MMM-YY or MMM'YY or MMM YY etc

[Scarbrain]

I have a string as per the below, the date can appear anywhere within the string, what is the best method to remove this text, as I want to see the text without any dates, so I can then join these further along in the workflow....

Alternatively, could you join these by ignoring the dates

Mar 25 customer name Lease Accruals
Feb 25 customer name Lease Accruals
customer namelease for Novt'24
customer namelease for Aug'23
Jan 25 customer name Lease Accruals
customer namelease for Aug'24
customer namelease for May'24
customer namelease for Dec'23
customer namelease for Oct'24
customer namelease for Feb'23
customer namelease for Apr'23

[flying008]

Hi, @Scarbrain 

FYI.

Spoiler

Trim(REGEX_Replace([Txt], "(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)[\s']\d{1,2}", ''))

******

If can help you get your want, please mark it as a solution and give a like for more share.

[Scarbrain]

@flying008  thanks, almost there, forgot to include this one 

Nov-24 Additional

Will mark as solution

[flying008 · Accepted solution]

Hi, @Scarbrain 

Try this again: (Nov 24  & Nov'24 & Nov-24)

Trim(REGEX_Replace([Txt], "(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)[\s'\-]\d{1,2}", ''))