Remove characters between brackets in a string

[#1]

Hi

I want to remove characters from field  that appear in brackets.

Product_A-(01)

Product_A-(02)

Product_A_Blue-(01)

Product_A_Blue-(02)

Should appear as;

Product_A-

Product_A_Blue-

Can anyone help with this?

Thanks

Danny

[Peter_Cammaert · Accepted solution]

=Left(Product, Index(Product, '(')-1)

[Anonymous]

PurgeChar(FieldName, '1234567890( )') as FieldName

[#4]

Perfect! Thanks!