Removing bracketed number from column data

[haymarketpaul]

QV11 SR4

I have data in one column that all have a bracketed number at the end that i would like to remove.

For example

It has things like...

Medical Update (34)

MIMS Spotlight Data (8)

Medec Finance Contract and Renewal (836)

As you can see there could be any number of digits in the brackets.  I would like to remove the brackets and the number in between and also the space before the ( bracket.

So based on the examples above i would end up with...

Medical Update

MIMS Spotlight Data

Medec Finance Contract and Renewal

Any ideas how best to achieve this?

[tresesco · Accepted solution]

Try like:

trim(SubField(YourData, '(',1))

[sunny_talwar]

or:

SubField(YourData, ' (', 1)

[Chanty4u]

PurgeChar(Field,'value') as NewField

[mohan2391]

You can also try

=PurgeChar(fieldname,'()1234567890')

[haymarketpaul]

Some of the names have got numbers in them too - thank you though