On May 23, 8:41*pm, Ron Rosenfeld wrote:
On Mon, 23 May 2011 06:10:33 -0700 (PDT), wrote:
Thanks for looking at this. *Yes, I will need to look at multiple
columns to match but I was figuring if I could get the basic 'match'
formula I could adapt it to handle the additional columns. *Can you
explain for example why the the '700 W Forest Av' doesn't match? *I.e.
why doesn't it match on the word 'Forest'?
700 W FOREST AVE

700 West Forest Suite 200

The match and various comparison functions look for one string within another. *They don't, for example, look to see that there are matches of the:
* * * * First Word: * * * * * * * * * * 700
* * * * First letter of second word: * *W
* * * * Third word: * * * * * * * * * * Forest
* * * * no match of the fourth word: * *AVE

and conclude, "Well, that's good enough; let's call it a match!"

It doesn't match because you have not stated any rules for matching fragments. *So looking for "700 W FOREST AVE" within the string "700 West Forest Suite 200" will fail after the "W"

A human can tell that this is likely at the same street address, but there are certainly any number of towns where there might be, for example, a Forest Ave; Forest St.; Forest Blvd; etc.

So I guess there is no easy way of doing this then. Thanks for your
input.