Removing text within parenthesis and the parenthesis from cells

dgpaul10

Afternoon,

I trying to find a way to remove text that is at the end of each cell the exists within parenthesis.

For Example

Dillon Jones (DGJ)

Lewis (LP)

Jordan Caine (JC)

And I just want to display

Dillon Jones

Lewis

Jordan Caine

i have tried to use the regex tool but it does not seem to recognize searching for the "(" and I am not sure it that is because it is looking the countering ")"

Any insight would be greatly appreciated.

Thanks!

Parse

Accepted answers

patrick_digan

@dgpaul10 ( is a special regex character, so you would have to precede it with a \ to denote the actual ( character. For example:

Regex_Replace([Field1]," \(.*?\)","")

seemed to work on my end...

All comments

patrick_digan

@dgpaul10 ( is a special regex character, so you would have to precede it with a \ to denote the actual ( character. For example:

Regex_Replace([Field1]," \(.*?\)","")

seemed to work on my end...

dgpaul10

Worked great!

Thanks!

davidhenington

Ask and you shall receive! I had totally forgotten about special chars! Using regex to build dynamic input in-db boooyah!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703