I have flat file test.txt is like:
id1 prashant ABCDEF
id2 pds CDHI
id3 pdshah ABCD
id4 pshah ABCDEFHIJKLM
id5 bako XY
..
Now I am loading this file into EXT table. So Table exactly looks like above file.
CUST_EXT table:
id Name DivCode
===== ======= =========
id1 prashant ABCDEF
id2 pds CDHI
id3 pdshah ABCD
id4 pshah ABCDEFHIJKLM
id5 bako XY
..

How can I make records like:????
id Name DivCode
===== ======= =========
id1 prashant AB
id1 prashant CD
id1 prashant EF

id2 pds CD
id2 pds HI

id3 pdshah AB
id3 pdshah CD

id4 pshah AB
id4 pshah CD
id4 pshah EF
id4 pshah HI
id4 pshah JK
id4 pshah LM

id5 bako XY

FYI:
I did if the records are AB CD EF but I am unable to parse the record if ABCDEF?
Your help will be really appreciated.
If you send me @poratips@hotmail.com that also good.


Regards,
Prashant