Attempting to match data

[bvolles]

Hello all,

I am hoping I can get a little assistance in matching garbage data.  I have to Excel tabs see below

Tab1

Group ID	Group Name
012345	Legacy Healthcare Services
543210	Brame Specialty
000023	Triad Medical Services
ABCD	AW North Carolina

Tab2

Subject

January 2021 North State Communications - Monthly Reports #$* %%%

January 2021 North State Communications - Monthly Reports #$* %%%

January 2021 North State Communications - Monthly Reports #$* %%%

January 2021 North State Communications - Monthly Reports #$* %%%

January 2021 Forsyth Country Day School (Non PHI) - Monthly Reports !@^ %%%

January 2021 Forsyth Country Day School (Non PHI) - Monthly Reports !@^ %%%

January 2021 Forsyth Country Day School (Non PHI) - Monthly Reports !@^ %%%

What I need to do is remove everything before the name of the group so January 2021 would need to be removed and then everything from the - onwards.  The issue is that the string length varies.  I am thinking this might be a regex use case but I just cant seem to get it to work.  Any thoughts/ideas/solutions are much appreciated.

[messi007 · Accepted solution]

@bvolles,

Please see below how you can do it :

Attached the workflow,

Hope this helps!

Regards,

[bvolles]

Yea I was thinking it would be regex.  Thank you so much!!

[bvolles]

@messi007  What if I wanted to remove the (Non PHI) after some of the names?

[messi007 · Accepted solution]

@bvolles,

Here you go!

Attached the workflow.

Regards

[bvolles]

Works perfect Thank you!!