Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Matcher (v2000)

    I am building an application that compares data from two vendors. They each maintain a table that has common fields in addition to fields unique to the vendor.

    What I want to do is compare the data in the common fields. For instance, each table has a part description. In a perfect world, I would create a calc [PartDescr1]=[PartDescr2] and look for instances where they aren't equal. However, one vendor uses the term 'First Aid Kit' while the other uses the term 'Kit - First Aid'. I plan on setting up a simple table to bridge obvious gaps like this that converts one term to match with the other.

    However, I would also like to build a feature like they use in the search engines that will look at one phrase and tell you the % that matches the other phrase. For instance, 'Quarter Panel' and 'Fender Panel' would be a 50% match and 'Front left hubcap' and 'Front driver side hubcap' would also be 50% since only 2 of the 4 words from phrase two are present in phrase one (I understand we have to pick one side to run the calc)

    If someone has something that might work, I would really appreciate it. If this seems like a crazy request, feel free to let me know that too.
    Thanks!!
    Dashiell

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Text Matcher (v2000)

    Sounds like a fun project. Good luck! (Which means I've never done this before, so I can't offer you any meaningful advice!)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Text Matcher (v2000)

    Search engines use fuzzy logic, which is a special form of logic and is NOT built into VBA. In VBA you would have to use the Split function to break the phrase into separate words, search for each word individually and for various combinations of the words with wildcards. VBA isn't really suited for this, and I doubt seriously that you will find an algorithm that will make it workable in VBA ... at least, not if you expect the search results within the next week or so. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Matcher (v2000)

    Just asking something that you and Charlotte didn't have ready in your bag of tricks makes me happy.
    Thanks!

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Text Matcher (v2000)

    Anything to please! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Charlotte

  6. #6
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Matcher (v2000)

    Actually, I started doing something like this. I don't think I finished it, but I can dig through my files to look for it. What I did to get around the problem of VBA's slowness was parse every text string into it's separate words (I don't think I used split, even though that probably would've made my life easier), and then write the words to a table. Then I could use a query to find the best matches, which is much faster than VBA. My memory is a bit fuzzy about exactly what I did, so I can't remember if I had problems or just got too busy to finish it.

  7. #7
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Matcher (v2000)

    Hi

    I had a fiddle around on this problem, and the attached seems to work. I can foresee some problems with it, but if you are still interested, have a look at it.

    Regards
    WTH
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •