Is that likely to be more efficient than the lookup? Or is it only so because the reference set is so small?
pick 78-81 == /CGA/, /RMH/, /BMI/ On 18 August 2011 13:46, Colin Allinson <[email protected]> wrote: > Rob van der Heij <[email protected]> wrote :- > >>> columns 78-81 being one of 3 values - but this would be easy in a > separate > >> | l: lookup 78.3 1.3 detail .. > >> \ literal CGA RMH IBM | split | l: > > Yes - that was the easy bit. That is one of at least 3 different ways > I can think of doing it. I only mentioned it in case I was being > obtuse and it could easily be incorporated into one stage with the > other check. (I know I am often obtuse - but lets gloss over that). > > > Colin Allinson > Amadeus Data Processing GmbH > Aviva is the trading name for the principal subsidiaries of the Aviva Group in the United Kingdom. The principal subsidiaries are: Aviva Insurance UK Limited. Registered Office 8 Surrey Street, Norwich, Norfolk NR1 3NG. Registered in England Number 99122. Authorised and regulated by the Financial Services Authority. Aviva Life Services UK Limited. Registered Office 2 Rougier Street, York YO90 1UU. Registered in England Number 2403746. Authorised and regulated by the Financial Services Authority. Aviva Health UK Limited. Registered Office 8 Surrey Street, Norwich, Norfolk NR1 3NG. Registered in England Number 2464270. Authorised and regulated by the Financial Services Authority. ********************************************************************** This email and any files sent with it are intended only for the named recipient. If you are not the named recipient please telephone/email the sender immediately. You should not disclose the content or take/retain/distribute any copies. **********************************************************************
