With the Fuzzy Lookup algorithms, which search for an approximate match, has anyone come across anything which gives more than one result.
The code below gives one result.
Capture.PNGPlease Login or Register to view this content.
With the Fuzzy Lookup algorithms, which search for an approximate match, has anyone come across anything which gives more than one result.
The code below gives one result.
Capture.PNGPlease Login or Register to view this content.
I've put up a searchable dropdown list here before which is similar to what you seem to be looking for. No fuzzy logic though.
OK thanks, I'll see if I can use the logic in Visual Basic.
Just quickly looking at your code though, it seems that if you extend your 'Value' string for each match... Value = Value & "," & str
if should give you more like what you want.
I can't seem to work through it.
ok...I had a bit longer to look at your code and it didn't find matches based on the characters I looked for, so I've made some suggestions for you.
You may want to tidy it up and tweak the magic number, but I've tried to stick as close as possible to your original algorithm.
Please Login or Register to view this content.
Thanks Croweater but I couldn't see how more than one result is given.
I tried another way which is to use a Levenshtein distance function commonly shown in a browse search, which returns a number. I go to the point of creating an array of results, and then re-ordering this array.
There is an issue with the order though because it looks at the leading digit first, so a value of 10 is treated as smaller than a value of 9.
Please Login or Register to view this content.
What do you mean "I couldn't see how more than one result is given."?
Did you try the code with the modifications?
Yes I did try it. It doesn't seem to fill in ranges B3 to B6.
Well it all depends on what you typed in as a search string and how closely it matches the names in the search doesn't it.
If you search for 'L Bird' for example it will only find one match. If you search 'Bill' though it will find more.
If you want to be less stringent with the search, lower the 'magic number' in the code.
Did you try multiple searches?
Yes you're right, sorry about that.
For some reason I couldn't work through this one.
Thanks for the providing code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks