Cutextract parts of a url from a table column

[wanglunberlin]

Hi,
i have a table with urls and other columns i would like to extract parts of the url in a new column.
the pattern of the url www.webseite.de/text/123456789/mehrtext/1/
i would like to extract the variable number sequence from the utl in a new column. i don’t need the /1/ at the end.
many thanks

[gonhaddock]

Hello @wanglunberlin

You can test with a ‘String Manipulation’ node with the following code:

regexReplace($url$, ".*?(\\d+).*", "$1")

BR

[wanglunberlin]

Very cool! Worked perfectly. Many thanks!