Have you considered the WILDCARD stage? Mike Walter Hewitt Associates
----- Original Message ----- From: "Bob Cronin" [EMAIL PROTECTED] Sent: 12/02/2008 04:11 PM EST To: [email protected] Subject: Need ideas for a lookup-like capability with a twist I have a list of domain names, e.g. "geodis.de lenovo.com att.com", etc. I have another list of (malformed) email addresses, e.g. "bcgeodis.de mfclenovo.com rrcatt.com", etc. I want to (somehow) use the list of domains and find those email addresses that END in any of the domain names (and then, of course, fix them up to insert the assumed-missing at-sign). It strikes me this this is a bit like lookup, but with modified matching criteria. It'd be infinitely cool if you could have lookup isolate the two fields being compared and pass them to an external function that could implement any sort of test it wanted (returning 1 if it worked, or 0 if it did not). Failing that (if you'll excuse the expression) pipedream being realized, does anyone have any other ideas how I might tackle this? Cheers, bc 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.
