This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I trying to find a way to remove text that is at the end of each cell the exists within parenthesis.
Dillon Jones (DGJ)
Jordan Caine (JC)
And I just want to display
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.
Go to Solution.
Go to Solution.
@dgpaul10 ( is a special regex character, so you would have to precede it with a \ to denote the actual ( character. For example:
seemed to work on my end...
I'm looking the opposite solution and will you please help me.
Example: I've field text as below -
1) Data Base (DB)
2) Data Analytics (DA)
3) Big Data (BA)
Need the the output in the field only withing parenthesis text as below -
Slightly different process:
1) use Regex tool to tokenise and extract the parenthesis. Then clean using regex tool in replacement mode.
It is working, Thank you so much.
Ask and you shall receive! I had totally forgotten about special chars! Using regex to build dynamic input in-db boooyah!
I have a similar problem to the one you solved above. Except for I have multiple parentheses in my cell. For example:
This (0.123%) is a (4.567%) test (95%).
I want the output to be (0.123%)(4.567%)(95%). Thank you so much in advance for your help!!