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.
