View previous topic :: View next topic
|
Author |
Message |
manikandanjs
New User
Joined: 02 Jun 2006 Posts: 27 Location: Blue Bell, PA
|
|
|
|
I have two files (file1) of length 100 and another file (file2). If the first seven bytes of the file1 is equal to the first seven byte of the file2, I need to copy the fields from position 10 to 16 of file2 into file1 (at the end). So the output file will have a length of 107 bytes.
Thanks,
Manikandan J |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
Back to top |
|
|
manikandanjs
New User
Joined: 02 Jun 2006 Posts: 27 Location: Blue Bell, PA
|
|
|
|
I'm able to do that successfully when file1 doesn't have any duplicate keys.
But it needs to be performed for the duplicate records as well.
Thanks,
Manikandan J |
|
Back to top |
|
|
manikandanjs
New User
Joined: 02 Jun 2006 Posts: 27 Location: Blue Bell, PA
|
|
|
|
Hi,
Could anybody know how to perform the above operation in ICETOOL or DFSORT if the file is having duplicate keys?
I'm not able to do for the duplicate key using ICETOOL (using SPLICE technique).
Thanks,
Manikandan J |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Manikandan,
Add WITHALL to the SPLICE statement -
Code: |
SPLICE FROM(TMP1) TO(OUT) ON(1,3,CH) WITHALL WITH(11,5) |
|
|
Back to top |
|
|
manikandanjs
New User
Joined: 02 Jun 2006 Posts: 27 Location: Blue Bell, PA
|
|
|
|
Thanks Murali, the output is coming correctly. |
|
Back to top |
|
|
|