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