AnsweredAssumed Answered

extracting variable text from text field

Question asked by maximums on Feb 19, 2012
Latest reply on Feb 19, 2012 by maximums

Hi all

 

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

 

cheers

Linda

Outcomes