On Tue, Dec 2, 2008 at 10:11 PM, Bob Cronin <[EMAIL PROTECTED]> wrote: > 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).
I once did something like this for matching dataset names, using a cascade of lookup stages, one for each key length. The secondary output of the 1st lookup goes to the primary input of the 2nd, etc. You probably need to arrange your cascade to have the one for the longest keys at the top. But maybe your list is such that it does not matter. If you don't like to match on the last columns of the detail record, you could reverse both key and detail before you start. -Rob
