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
