Re: Help needed with First/Last Name combinations

On Tue, 30 May 2006 08:28:31 -0400, Tony Ciconte
<tonyc219@xxxxxxxxxxx> wrote:

I have successfully integrated the Ratcliff/Obershelp algorithm, which
calculates the similarity between two strings. Anything over a certain
threshold would be run by the user: "Is it one of these?". AFAIK it is
only available in C.

-Tom.



Does anyone know of or have any VBA code or similar logic that can
help distinguish similar first/last name combinations? For example, we
would like to prompt the user of a possible match when any of the
first/last names Robert Smith, or Bob Smith, or Robt. Smith are used
during data entry. All that is necessary is to alert the user so that
they can review any appropriate existing records.

We have done several google searches without any luck. Any and all
help is appreciated.

TC

.

Relevant Pages

  • My Johnny Smith Story
    ... We arrived at the store and she had to make me get out of the car. ... I could see what looked exactly like the album cover. ... to know it was Johnny Smith. ... He did....and I didn't change those strings for years. ...
    (rec.music.makers.guitar.jazz)
  • Re: re.compile for names
    ... The goal of the list is to have enough strings to identify files that may contain the names of people. ... These days you can't even rely on names starting with a capital letter ("i think paris hilton is do u 2"). ... Much depends on context, if you want to cut down on false positives -- "we went 2 paris n staid at the hilton", "the bill from the smith was too high". ...
    (comp.lang.python)
  • Re: Search-and-delete text processing problem...
    ... Strings have many methods that are worth learning. ... > which might be like "Bill D. Smith, History through the Ages, p.5". ... allLines = theInFile.readlines ...
    (comp.lang.python)
  • Re: entering text within a file
    ... the curren code below is replacing E strings with eject strings ... Derek B. Smith ...
    (perl.beginners)
  • Re: DR Flatwounds
    ... The only time to buy the designer ... strings is at those shows. ... Joe ... Max Smith wrote: ...
    (rec.music.makers.guitar.jazz)