Regex Split

Hi everybody. I have to split a column that contains strings but haven’t been able to solve it. So I need to separate the string by a specific set of words. I’ll add a table to make more visual.

| INPUT                                    | DESIRED OUTPUT 1       | DESIRED OUTPUT 2      |
| 2024 Campaign 1 BHV Shoppable Display    | 2024 Campaign 1        | BHV Shoppable Display |
| Campaign 1 2024_Feb KW Shoppable Display | Campaign 1 2024_Feb    | KW Shoppable Display  |
| Program 1 Feruary_2024 Banner Display    | Program 1 Feruary_2024 | Banner Display        |

so i was thinking I could split by these specific words such as “KW Shoppable Display” , “Banner Display” etc… since they are always the same words. However I dont have any specific numer of caracthers to split by, or any delimiter. Only I know its they are always the same words.

Is there any way I can split by these specific strings with regex? I tried cell splitter, string manipulation, and regex split but haven’t figured it out.

I’d appreciate any help on this.

Thank you