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

    Compare Two Fields (Spell Check)

    Hardik Gandhi



      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



      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.