4 Replies Latest reply on Jun 5, 2018 11:52 PM by naveen kumar

    How can we divide Email list column into three separate columns

    naveen kumar

      Hello everyone,

       

      Please help me in splitting the emaillist column into three columns.

      for example: If naveen@CGI.in is the data present in emaillist column.

      how can we get into three separate columns 1.Name, 2.Company and 3.Country

       

      I am using split, but could able to get the company value only.

       

      SPLIT( [Email list], "@", 1 )  -- this calculation gives us name from emaillist

      SPLIT( [Email list], ".", 2 )  -- this calculation gives us Country from emaillist

       

      but I am not able to get the company value only.

      Please let me know the solution or suggest few other ways to achieve this.

       

       

      Thanks,

      Naveen.