7 Replies Latest reply: Mar 16, 2013 10:48 AM by Sunil Chauhan RSS

    how to separate field

    rohit gupta

      hi all

      i have data in notepad shown below

      Sample1:

      eid|name|salary

      123|ravi|100

      234|arun|200

      345|rathish|300

      456|rohit|400

       

      sample2:

      barcode|value

      000001|10000

      0 1012|20000

      00 111|30000

      002222|30000

      000088|40000

      now what i want ...table should seen like this

       


      eid

      123

      234
      345
      456

      same  for others....plz help me

      thanks rohit