4 Replies Latest reply: May 20, 2014 4:27 AM by whiteline _ RSS

    delimiter in script

    Pandiarajan Radhakrishnan

      Dear friends,

       

      My Original Table

       

      Branch          Employees  

      Agra             aaa|aaa|bbb|CCC

      Patna          AAA|ccc


      Result Shoul Be


      Branch   Employees

      Agra       aaa

      Agra       aaa

      Agra       bbb

      Agra       CCC

      Patna     AAA

      Patna     ccc


      if i was use subfield

      Branch   Employees

      Agra       aaa

      Agra       bbb

      Agra       CCC

      Patna     AAA

      Patna     ccc


      but i need


      Branch   Employees

      Agra       aaa

      Agra       aaa

      Agra       bbb

      Agra       CCC

      Patna     AAA

      Patna     ccc


      please help me someone