Extract regex from URL

[iagovar]

So I have a list of URLs where I need to extract the Discussion ID, with varying lenghts and properties.

https://www.domain.es/forum-radom-subforum-name/discussion-name-75427-post2571462.html#post2571462

I’ve came up with this regex \d++(?=-), which is the data (75427) I want to exactract.

Now, how I do this? I can easily do it with PowerQuery and Column by Example but I can’t find a way to do it in knime. Tried with rule engine but I don’t get any results.

[armingrudd]

Hi @iagovar,

Regarding your example, you could use this expression in the String Manipulation node:

regexReplace($column1$, ".*-(\\d+)-.*", "$1")

Where “column1” is the name of the column containing the URLs.

[iagovar]

@iagovar

\d++(?=-)

Thanks, it worked.

If I wanted to use \d++(?=-) how should I encapsulate it?

[armingrudd]

Not sure what exactly you are talking about but I am sure you can find your answers about regex here:

https://www.regular-expressions.info/