Identify numbers in cells with Text


I have a column called ‘ID’ and this column contains ID’s. Every ID has nine numbers. But the problem is, that in this column is also a Text inside. But I only need the ID’s without a text. So, is it possible to create a second column only with the ID’s inside? Which nodes and settings should I use?

Thank you.

Hi Frank,

check out Palladian’s Regex Extractor. (some more background about the node e.g. here and here)

With a simple expression \d{8} and the ouput option “List” you’ll get all extracted IDs:

Sample workflow on my NodePit Space:

Does this help?


Thank you. This node is not available in my Knime. How can I install this node?

Just add this update site URL to your KNIME preferences:

Then go to the File: Install KNIME Extensions … menu and there select Palladian.

Alternatively, you can also do the installation using the NodePit plugin, which makes it more convenient to install additional further extensions in the future (and give you access to features such as NodePit space). More details are available here.

Best regards,

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.