Date: Fri, 20 Jan 2006 13:58:32 -0800
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: trying to match on email address
Content-Type: text/plain; format=flowed
> I have two files. each file holds email addresses. I know that at
>least one email address in file A matches an email address in file B.
> I have used a length email1 $38 on both. I have done email1 =
>lowcase(trim(left(email) on both.
> I still get no matches.
You may not be able to get any matches, even though there are addresses in
file A which map to the same address as in file B. Are the following
Short answer? At one time, all of these were legal addresses that would
(Spammers, have fun - these are no longer valid addresses for me.)
So you may have features involving mail administration and email routing
which may totally mess up your matching. I think you need to try sorting
both files and just *looking*. Can you find features that need to be
accounted for? Do you need to take the name before the '@' apart
and check individual components? Do you need to pull apart the destination
after the '@' and look for pieces to throw away or other ways to re-combine?
This could be a monumental headache to match up *all* addresses.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Express yourself instantly with MSN Messenger! Download today - it's FREE!