相关文章推荐

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

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.

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

 
推荐文章