Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try like:
trim(SubField(YourData, '(',1))
or:
SubField(YourData, ' (', 1)
PurgeChar(Field,'value') as NewField
You can also try
=PurgeChar(fieldname,'()1234567890')
Some of the names have got numbers in them too - thank you though