Remove strings after "-" and "|"

[jatienza]

Hi,

Need help in removing strings after "-" and "|" and removed also the "-" and "|", please see below.

Raw data:

Company A - Class

Company B | Class

Company-C - Class

Company | D | Class

Output:

Company A

Company B

Company-C

Company | D

Thanks,

Jaime

[binu_acs · Accepted solution]

@jatienza One way of doing this

[ShankerV · Accepted solution]

Hi @jatienza 

Please find the expected result.

[jatienza]

Thanks! @binu_acs @ShankerV