Regex Parse

Question

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 TitleDesired OutputCompany Name: Training 11 Training Name 2022Training 11 Training NameCompany Name: Training 12 2022Training 12

Luke_C · Answer

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

New Workflow4.yxmd

Qiu · Answer

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

0624-elclark.yxmd