Extract text between second set of "(" and ")"

[tb_g_23]

Hi everyone!

I have the following column with the product name and unit measure in between parenthesis.

There are several products that have more than one set of ( ) , what node and expression should I use to return the text between the second set of parenthesis?

Example: 21-0-0-24 Ammonium Sulfate (AMS) (tn) —> tn

Thank you all for your help.

[elsamuel]

Welcome to the forum, @tb_g_23.

I’d use the Regex Extractor node for this; the expression \(([^)]+)\)$ gives the desired result:

[tb_g_23]

Thank you! Seems straight forward.
Where can I find this node to install?
Might be an amateur question, I can’t seem find the Regex Extractor node available to install. I’ve searched the installed node repository and the community hub. I have the latest build of KNIME installed.

[elsamuel]

You can get it as part of the Palladian extension

Palladian for KNIME — NodePit

The sidebar on the right has installation instructions.