Hi
I'm trying to cross reference records from two different databases by first and last name.
I can pull most the records (about 1500 out of 1700) on straight forward comparison of
(a.firstname = b.firstname) and (a.lastname=b.lastname)
as for the rest, is there a way to check if one name is similiar to another (in case of a typo, or mis-spelling of the name)
Thanks,
Mike
similiar fields
Hot Topic
- Dynamically show and hide grid column
- copy to a textfile
- Runing Total
- Change output alignment in a Field control
- How to center "Report Picture" in a FoxPro 8.0 Report
- How to Get Serial of CPU......
- copy to a textfile
- createobject("mappoint.application)
- How to make a form truely private?
- function argument is invalid...
Visual FoxPro
- All the sudden a batch of records (that were already in the table) are appended again?!?
- Visual Foxpro Book Recommendations?
- about a project in VFP9
- How to find index on column in FoxPro
- End datasession users?
- VFP8.0 Chaining Reports
- report temp file not found
- Another question for the day, Listbox limits
- import from excel
- An icon instead a 'Memo' in grids.
similiar fields
ChocolateBoyWonder
Hi Mike
You could use something like a Levenshtein algorithm do to this.
There is some code on Ed Leafe's site http://leafe.com/dls/vfp by Bob Calco.
HTH,
Robbo.
Thundermaker
Ross Watson
That narrows a few of them down.
Mike
rod 001
Not an easy task as there could be many spellings, punctuation, etc.
You could try SOUNDEX() although it only works for English expressions/names and has limited use at that.
hokietoner
If you have additional information in the tables about the individual it may help to cross-reference those as well.
IE. Email address, Phone Numbers ect.
Another idea is to write a function that cleans the data.. Strip out spaces and all non-letter characters, Make all uppercase ect.
Dave