How to extract YEAR from a string?

User: "Kaloki"
New Altair Community Member
Updated by Jocelyn
Hi,

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...
Thanks.

Find more posts tagged with