0 Replies Latest reply: Oct 5, 2012 10:49 AM by Hardik Gandhi RSS

    Compare Two Fields (Spell Check)

    Hardik Gandhi

      Hi,

       

      I have come across this issue where I need to do spell check between two name fields.

       

      Database1: Member table - Field name: Member Name

      Database2: Customer Table - Field name: Customer Name

       

      Scenario1:

      Member Name: John Doe

      Customer Name: John Doee

       

      Member Name: ANNA LIKED

      Customer Name: ANA LIKED

       

      In the above scenario both name are close match between Member name and Customer Name. I want to write a script which will compare such close association between names and flag it with 'YES' if matches and 'NO' if it do not.

       

      Thanks,

      H