Extracting text from an inconsistent string of text

[Sara_Ophoff]

Hello! I am currently trying to extract information from an inconsistent string of text and having a tough time.

Ideally, I would be able to drop the MONTH and DATE from the String of text and KEEP the all the text along with just theYEAR. 

The trouble is, both the intro text (represented as X's) and the dates are not consistent lengths. 

EXAMPLES OF TEXT:	DESIRED OUTPUT:
XXXXX.RTW.Men.7.5.2023	XXXXX.RTW.Men.2023
XXX.RTW.Women.12.10.2022	XXX.RTW.Women.2022
XXXX.RTW.11.6.2022	XXXX.RTW.2022

Is there a formula that can do this? I am not great at these types of formulas (and I feel like this is potentially very simple!) - hoping someone can help! 

Let me know if I can provide further info to provide a solution. Thank you in advance for your help! 

[Sho · Accepted solution]

Hello @Sara_Ophoff ,

For Regex, it's like this.

REGEX_REPLACE({Text},".\\d+.\\d+.",".")

[Sara_Ophoff]

@Sho thank you!!!! This worked perfectly!!