Regex Parse

[elclark]

Hello - I'm trying to parse these titles, the names are inconsistent and the year gets updated every year. Essentially I want to parse it out so all I have is the full name of the training and remove everything from before the colon and the year. Here are examples. Thanks.

Current Title	Desired Output
Company Name: Training 11 Training Name 2022	Training 11 Training Name
Company Name: Training 12 2022	Training 12

[Qiu]

@elclark 
I take the string after the column and the 4 digit number, and hope this is correct.

[Luke_C]

Hi @elclark 

To offer a non-regex solution: 

Substring + Findstring: Get characters after the colon

Replace/Get Word/Count Words: Remove the year from the end