topic Re: Removing bracketed number from column data in QlikView

Removing bracketed number from column data

haymarketpaul — Thu, 07 Jan 2016 12:26:47 GMT

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?

Re: Removing bracketed number from column data

tresB — Thu, 07 Jan 2016 12:29:02 GMT

Try like:

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

Re: Removing bracketed number from column data

sunny_talwar — Thu, 07 Jan 2016 12:30:59 GMT

or:

SubField(YourData, ' (', 1)

Re: Removing bracketed number from column data

Chanty4u — Thu, 07 Jan 2016 12:32:53 GMT

PurgeChar(Field,'value') as NewField

Re: Removing bracketed number from column data

mohan2391 — Thu, 07 Jan 2016 13:19:43 GMT

You can also try

=PurgeChar(fieldname,'()1234567890')

Re: Removing bracketed number from column data

haymarketpaul — Thu, 07 Jan 2016 16:01:38 GMT

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