Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparison between two similar strings
Hi,
I have two arrays of name and I would like to check if some of the names are present in both of the arrays. But the names can be mispelled, or differently entered in the two arrays, for example: -Alberto Parreira , albeerto parteira -alberto parreira , alberto juan fernandez parreira -alberto-juan parreira , alberto juuan parreira Do you have an idea of a function that could tell me: those two strings represents (at for example 80% sure) the same person ? Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparison between two similar strings
http://www.merriampark.com/ld.htm Levenshtein Distance Algorithm. Link has sample code in VB. Soundex is another approach. Your second example would be difficult to call the same I would guess. http://www.levenshtein.net/levenshtein_links.htm -- Regards, Tom Ogilvy "Matt" wrote: Hi, I have two arrays of name and I would like to check if some of the names are present in both of the arrays. But the names can be mispelled, or differently entered in the two arrays, for example: -Alberto Parreira , albeerto parteira -alberto parreira , alberto juan fernandez parreira -alberto-juan parreira , alberto juuan parreira Do you have an idea of a function that could tell me: those two strings represents (at for example 80% sure) the same person ? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read contents of col 1 and extract similar strings | Excel Discussion (Misc queries) | |||
comparison similar rows in Excel | Excel Discussion (Misc queries) | |||
Comparison - Strings and Arrays | Excel Programming | |||
similar vs. exact comparison | Excel Discussion (Misc queries) | |||
Similar vs. Exact comparison | Excel Programming |