The problem i am facing is i have to read a text file which is like
BAS
00064491/000002-TXL-00002
00064492/000003-AJS-00003
AJSS
00064495/000006-TUL-00006
00064496/000007-YAK-00007
JJC
00064498/000009-KTR-00009
00064499/000010-JOA-00010
i want that it adds it in database fields as whenever it encounters line with five or less characters its adds in field1 and then the corresponding rows in filed 2 with field1 with same values till the new value arrives
like
Field1 Filed2
BAS 00064491/000002-TXL-00002
BAS 00064492/000003-AJS-00003
AJSS 00064495/000006-TUL-00006
AJSS 00064496/000007-YAK-00007

and so on .... please help me in this as i have code written but not working as needed...Urgently need help.....