1 Reply Latest reply: Oct 25, 2016 11:57 AM by Sunny Talwar RSS

    Truncating and keeping data in different rows for a single ID

    Rakesh Paul

      Hi All,

       

      I have a data set like bellow mentioned -

      IDNo
      1AA751485:AA750402:AA750402:AA2503271:AA751716
      2MBJ-AA3EM1

       

      And I want the Output as below-

       

      IDNo
      1AA751485
      1AA751485
      1AA750402
      1AA2503271
      1AA751716
      2MBJ-AA3EM1

       

      Can you please help me in getting this sorted.

       

      Regards,

      Rakesh Paul