I have text in a field and I want to strip out the number below after the last bracket '('

Hi all, hoping somebody can help. I have text in a field and I want to strip out the number below after the last bracket ‘(’. In some instances a question may have one or more brackets in it hence it’s just the text after the last bracket to strip/not display)

This is what it looks like in the backend currently:

For a different field, I’ve used this on basis that the text in the field doesn’t have brackets but it won’t work where there are two brackets.

Greatly appreciated.

Robert

Hi there, @robstudy… is it always a number inside the last set of brackets and would another set of brackets in the string not contain only a number? If so, a find and replace with this regex should do the trick.

Here it is if you want to copy and paste it: (\([0-9]*\))

Hope this helps.

Best…
Mike

1 Like

Thanks Mike, appreciated, will have a go with that shortly.

1 Like