7 Replies Latest reply: Mar 27, 2014 9:24 AM by sunil kumar RSS

    Function to match two items

    David Young

      HI All,

       

      I am not sure this can be done but wanted to throw it out and see if anyone can help:

       

      The Problem:  I have two tables with Vendor Information listed and the vendor is spelled slightly different in both tables.  Is there a way to do some match, fix, or anything else to correct the issue.  Here is an example of what I am talking about:

       

      Vendor Table 1

      AEP-Energy

       

      Vendor Table 2

      AEPEnergy

       

      In other words the Vendor name in both list is the same but spelled slightly different.  Is there any tricks out there.

       

      David