Removing a sequence inside of brackets from a string

Asked Feb 15 '22 at 09:59

Active Feb 15 '22 at 09:59

Viewed 41 times

I have some data with a field that looks somewhat like this:

(1234) abcd, efgh (5678)

I need to remove the characters inside the brackets, so that my output looks like this:

abcd, efgh

I tried using REGEXP_REPLACE("(1234) abcd, efgh (5678)","[(.*?)]" , ""), this however only removes the brackets and leaves the characters inside. I am not really familiar with regular expressions. Can you help? Thanks in advance!

asked Feb 15 '22 at 09:59

Hendiadyoin

I have tried this already, unfortunately it does not work. Big Query throws me an error: `Syntax error: Illegal escape sequence: \( at [1:51]` – Hendiadyoin Feb 15 '22 at 10:03
Just escape the parentheses with ``\\``, like `REGEXP_REPLACE("(1234) abcd, efgh (5678)","\\(.*?\\)" , "")`. Also, you can use `REGEXP_REPLACE("(1234) abcd, efgh (5678)","\\([^()]*\\)" , "")` – Wiktor Stribiżew Feb 15 '22 at 10:06
nice, thank you! – Hendiadyoin Feb 15 '22 at 13:00

Removing a sequence inside of brackets from a string

0 Answers0