I hadn't but I am now! :-) Thanks for the idea. Cheers, bc
On Tue, Dec 2, 2008 at 7:16 PM, Mike Walter <[EMAIL PROTECTED]> wrote: > 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. >
