I've multiple data columns containing data in given format below, need help with regex formula expression for formula tool using which I can select data before brackets
I know this can be achieved individually using regex or text to columns tools, but I want to process it in one go
eg:
input | Output |
Apple (1234) | Apple |
Barking Dog (2134) | Barking |
Grumpy Cat (981901) | Grumpy Cat |
Any help would be appreciated!.
Thanks in Advance.
Regards,
Suhail
Solved! Go to Solution.
a simple expression:
regex_replace([stuff], "(.*?)\s*\(.*", '$1')
cheers,
mark
regex101.com
It worked.
Thank you Mark!!