What about (untested) .. read details ... '|Insert x15 After', '|split 0 before sting /:FIXED/', '|LK: Lookup W3 W1 Detail Master', '|SPEC 1-* 1 Read W3 NextWord', '|In: FaninAny', '|Deblock Linend 15', .... you output '?.... Read masters.... '|LK:', '|SPEC 1-* "n:a" NewtWord|In:'
I think I should be close..... 2011/3/17 Mike Walter <[email protected]> > Given a master file with records like: > > lua x APP1 > lub x APP2 > luc x APP3 > lud x APP4 > > And a detail file containing records like: > :FIXEDA MISC.DATA :FIXEDP BLAHA lua :FIXEDP BLAHX lua :FIXEDP BLAHJ > luc > :FIXEDA MISC.DATA :FIXEDP BLAHB luc :FIXEDP BLAHQ fail :FIXEDP BLAHR > lud :FIXEDP BLAHJ lud (more :FIXEDP's?) > :FIXEDA MISC.DATA :FIXEDP BLAHC lub > > Goal: > :FIXEDA MISC.DATA :FIXEDP BLAHM lua APP1 :FIXEDP BLAHR lua APP1 :FIXEDP > BLAHW luc APP3 > :FIXEDA MISC.DATA :FIXEDP BLAHJ luc APP3 :FIXEDP BLAHP fail n/a :FIXEDP > BLAHH lud APP4 :FIXEDP BLAHJ ddd APP4 > :FIXEDA MISC.DATA :FIXEDP BLAHA lub APP3 > > (The given words are just examples, not even close to the actual file > contents.) > There is no pattern to the 2nd word after each :FIXEDP (shown as lowercase > strings herein just to make them stand out in the examples). > > How do I LOOKUP the 2nd word after each ":FIXEDP" in the detail file > against in the 1st word of the master file, and (this is the problem) > insert the 3rd word from the matching master file record without a stall > or loss of data integrity? > > Additional difficulty points will be awarded for a working example > permitting append of a text string when the lookup fails (in the example: > "fail n/a"). > > Everything I've tried has failed due to LOOKUP's delay. If I could even > think of decent search arguments, I'd search the list for previously > posted examples. > > TIA > > Mike Walter > Aon Corporation > The opinions expressed herein are mine alone, not my employer's. > > > > The information contained in this e-mail and any accompanying documents may > contain information that is confidential or otherwise protected from > disclosure. If you are not the intended recipient of this message, or if > this message has been addressed to you in error, please immediately alert > the sender by reply e-mail and then delete this message, including any > attachments. Any dissemination, distribution or other use of the contents of > this message by anyone other than the intended recipient is strictly > prohibited. All messages sent to and from this e-mail address may be > monitored as permitted by applicable law and regulations to ensure > compliance with our internal policies and to protect our business. E-mails > are not secure and cannot be guaranteed to be error free as they can be > intercepted, amended, lost or destroyed, or contain viruses. You are deemed > to have accepted these risks if you communicate with us by e-mail. > -- Kris Buelens, IBM Belgium, VM customer support
