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.