I have a characteristic that has entries as shown below;
ETAR Harrogate Sth to Esholt
ETAR Malton to Naburn
ET6W Foulridge to Skipton
My requirement to to get the text after 'to' and place in a new characteristic, so from ETAR Harrogate Sth to Esholt I need just the Esholt part, from ETAR Malton to Naburn I need just Naburn.
I have tried using the formulas in the transformation but haven't been able to do this yet.
Thanks in advance
Steve