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 :-)
