Regex extract only numbers

Hello everyone how can I create a column only with extraction of numbers using regex:

example:

input: Toy Story (1995)

what I need is:

output: 1995

Hi; maybe this can do what you want

1 Like

Use String Manipulation with regexReplace($Power Series$, “[^0-9]”, “”) function.

6 Likes

thanks in advance, but in my case I have several years and it would be a lot of work to type every year

thank you very much it worked!

2 Likes

Hello!

proposed regex solution works if there are no numbers in movies (or what ever strings represent) like Kill Bill: Vol. 2 under assumption you are only interested in year.

This regex in Regex Split node should covers above scenario as well:

.*[\(]([0-9]+)[\)]$

Also you can use reverse() function together with substring() function from String Manipulation node to obtain year only cause when reversed year always start as same position.

Br,
Ivan

1 Like

What you wrote really happened, there are entries like that too.

entry: Toy Story 1000 (1995)

more output that I wish is only the year

output: 1995

1 Like

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