-
Parse the value
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|