How to extract YEAR from a string?

KalokiKaloki Member Posts: 3 Learner I

I have this attribute in a dataset that is a string of text :
  • Name: "Angove's 2006 Red Belly Black Shiraz (South Australia)"

How do I create a new attribute, say Vintage and get to have only the year, e.g. 2006 in this case as the value of the new attribute?
  • Vintage: 2006
Appreciate any support.
Am using generate attribute operator, but can't quite work out the syntax correctly...

Best Answers

Sign In or Register to comment.