Regx Tool

[BRRLL99]

Hi

I looking to get the expected output with minimum tools using regex

DATA	OUTPUT
ABC S12 Shared Utility Supp- SA, BMS,DB	S12 Shared
ABC S12 Shared Utility Supp- SA, BMS,DB	S12 Shared
ABC S1-Common-Shared(CD+DC+Bio)-AMC&CMC	S1 Shared
S4 Sharing (EHSS & Safety **bleep**) Services	S4 Shared

[ShankerV · Accepted solution]

Hi @BRRLL99 

One way of doing this.

Many thanks

Shanker V