I have a field which contains the data imported and which I wish to breakdown. One of the elements I wish to extract is a four digit no for the year, and then post this to another field.

e.g.

Charmes Chambertin, Tres Vieilles Vignes 1999 (12)

I need '1999' to post to another field.

The no. of words before the year changes - can be 1, 2, 3, 4 or as here 5. There is always a number after this in brackets, as here e.g. '(12)'. Perhaps that helps? Any help much appreciated> Thank you.

Can there be any digits and/or brackets in the text before the year?

Thanks. There can be the odd thing like '1er' (my apostrophes) but so seldom it's not worth doing anything with this and can change manually as the year is inserted into a field which compares to a value list. Also, sometimes a '5' or '6' on its own but again v. rare. Otherwise no brackets or digits.

Try:

RightWords ( GetValue ( Substitute ( text ; "(" ; ¶ ) ; 1 ) ; 1 )

( there must be no carriage ruturn into the original text )

Or [color:blue]Leftwords ( RightWords ( text ; 2 ) ; 1 )

... but is it clear that there is no text after what has been given for an example? :wink2: