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
Solved! Go to Solution.
Hi, @Scarbrain
FYI.
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.
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}", ''))
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |