nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Regex Help (Extracting numbers between parentheses)

mvtthewcornelison

Hi Alteryx Community,

How can I replace all of the numbers between a parentheses which contain a number to nothing. For example:

CURRENT ----> RESULT...

Test company 123 (100%) ----> Test company 123

Test company 456 (i.e. tc456) (200%) ----> Test company 456

Test Company (TC) Holding AB (46,714,779 COMMON_SHARES) ----> Test Company (TC) Holding AB

So to further clarify the text I have to the right of ----> would be the current state, and the text to the right of ----> is what I would how to achieve after a regexreplace.

Thanks so much for your help! Please let me know if you need further clarification.

Regex

Accepted answers

Hi @mvtthewcornelison

Would something like this work?

Trim(Regex_Replace([Field1], "\([^)]*?\d[^)]*?\)", ""))

Basically it means if it finds a number between parenthesis, we should replace this full expression (including the parenthesis), with nothing.

Use this expression with the Trim function in the Formula Tool.

Cheers,

All comments

Hi @mvtthewcornelison ,

Hope this helps .

Hi @mvtthewcornelison

Would something like this work?

Trim(Regex_Replace([Field1], "\([^)]*?\d[^)]*?\)", ""))

Basically it means if it finds a number between parenthesis, we should replace this full expression (including the parenthesis), with nothing.

Use this expression with the Trim function in the Formula Tool.

Cheers,

Hi @mvtthewcornelison

Hello Regex my old friend...

[(]\d+.+[)]|[(].+\d+.[)]

That should do it.

I've attached the workflow. Let me know it doesn't work.

M.

solution_mceleavey.yxmd

mvtthewcornelison

Thank you so much for your reply..very close - didn't work for :

Test Company, LLC (0 COMMON_SHARES) Test Company2, LLC (0 COMMON_SHARES)

mvtthewcornelison

This worked!! Thank you so much for your help 🙂

Quick Links

Popular Tags

Child Item

This months top contributors

atcodedog05 19598

Qiu 15959

MarqueeCrew 13710

apathetichell 13703