0 Replies Latest reply on Nov 27, 2015 1:12 PM by Rohit_L

    Need to Remove Duplicate words from Table using Regular Expression:

    Rohit_L

      I have the below data & I want to remove the duplicates from column B using Regular Expression, Ex New Cap Grp is coming 5 times in 2nd row it should come only once.

      I am new to regular expressions & I have tried to do it but I am not able to remove all the duplicates.

       

      col a
      col b
      WDSAALT COMPANY, III & New Group
      1101New Cap Grp & New Cap Grp & New Cap Grp & New Cap Grp & New Cap Grp & New Cap Grp
      2255Tata Associates Inc. & Tata Associates Inc. & Tata Associates Inc. & Tata Associates Inc. & Towers Watson & Towers Watson
      3355Picard Lorens, Inc. & Tata Associates Inc. & Tata Associates Inc. & Tata Associates Inc. & Tata Associates Inc.
      8877Morphy Companies, Inc. & Morphy Companies, Inc. & Morphy Companies, Inc.

      If anyone knows how to do it then please share, thanks in advance.