==>Is there a way for LOOKUP to use the shorter of the two keys and match on ==>the now-equal shorter key length?
Not that I am aware of. I am watching this thread for some way cool suggestions. ____________________ Jim Hughes 603-271-5586 "It is fun to do the impossible." ==>-----Original Message----- ==>From: CMSTSO Pipelines Discussion List [mailto:CMS- ==>[email protected]] On Behalf Of Donald Russell ==>Sent: Monday, December 22, 2008 5:06 PM ==>To: [email protected] ==>Subject: Using lookup with abbreviated keys ==> ==>I have a list of detail records, and I'd like to select some of them ==>based on specifying an abbreviation of text in the detail record. ==>The abbreviations are different lengths. ==> ==>A contrived/simplified example is: ==>'PIPE (END ?)', ==> 'STRLITERAL /APPLE ARGENTINA BASKET BRASS/', ==> '| SPLIT', ==> '| A: LOOKUP PAD BLANK W1 W1 DETAIL', ==> '| CONSOLE', ==> '?', ==> 'STRLITERAL /AR BAS/', ==> '| SPLIT', ==> '| A:' ==> ==> ==>The result I was hoping for was to get the words ARGENTINA and BASKET, ==>instead I got nothing. ==> ==>I don't quite understand what PAD/NOPAD does... the doc says with ==>NOPAD the keys must be the same length to be considered equal. ==>OK. Since my master keys are always shorter than the detail keys, I ==>expect no results if I use NOPAD. ==> ==>So with PAD I can specify the character to pad the shorter key with, ==>and then the keys are compared... and... how will they match then? ==>Is there some sort of "wild card" I can pad with? STRFIND allows a ==>blank to match any character, so it seems reasonable that padding a ==>shorter key here with blanks might act like a wild character and ==>effectively match the prefix part. ==> ==>Is there a way for LOOKUP to use the shorter of the two keys and match on ==>the now-equal shorter key length? ==> ==>PIPE version is FPLINX086I CMS/TSO Pipelines, 5741-A05/5655-A17 1.0110 ==>(Version.Release/Mod) - Generated 11 Oct 2005 at 12:04:21 ==> ==>Thanks :-)
