Kenneth Kixmoeller/fh wrote:
Hey - - -
Working on d-f'ing up the information in a poorly-designed database.
Using SOUNDEX() for "close" comparisons. One it missed:
Highway Federal Credit Union = H200 F364 C633 U550
Hiway Federal Credit Union = H000 F364 C633 U550
I woulda thunk.... but then again, it ignores vowels... any soundex()
replacement out there????
You could also have a go at using Bob Calco's Levenshtein class for
matching strings. Not had a go of using it yet but will do next time I
have to do some de-duping.
ftp://leafe.com/levenshtein.zip
Peter
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.