How to extract YEAR from a string?
Hi,
I have this attribute in a dataset that is a string of text :
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?
Am using generate attribute operator, but can't quite work out the syntax correctly...
Thanks.
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
Am using generate attribute operator, but can't quite work out the syntax correctly...
Thanks.