Skip to Content
0
Former Member
Mar 20, 2009 at 11:23 AM

How to slipt fields in a row of an external file and store in Table

32 Views

Hi Experts,

I need to proces an External file and store into a table. Here need to Split the fields in a row and write as multiple rows of a table.

here i am giving the data sample ..

outlet1 type1 type2 type3

outlet2 type1 type3 type4 typ6 type7

The table should be as below.

outlet1 type1

outlet1 type2

outlet1 type2

outlet2 type1

outlet2 type3

outlet2 type4

outlet2 type6

outlet2 type7

Please give your suggesions and code sample that you have

Thanks