I need to turn the following 2 fields into result below:
Field 1: Microsoft Word 2010 Indroduction
Field 2: Microsoft Word Introduction
Desired Result: to extract 2010
The syntax in Field 1 is always constant, ie. product & version & level or product & version but the number of words or characters is variable.
The version can be text and digits and there are infinity possibilities
I've been messing around with various calculations but all I have achieved is a headache!
I hope somebody can clear the confused state I've put myself in