3 Replies Latest reply on Dec 26, 2017 9:44 PM by Zhouyi Zhang

    Split string values

    Andrew Morgan

      Hi Experts,

       

      I have data like below in excel and the expected output.

        

      IDExpected O/P
      pnrl 112334-1112334-1
      pnrl-15015-115015-1
      15015-215015-2
      15015-315015-3
      1501-11501-1
      156234-4156234-4

       

      How can I split the ID column to get the desired output?

       

      Would appreciate your help.

       

      Thanks in advance.

       

      AM