Sort/Merge question

skodidine · New User Joined: 05 Apr 2006 Posts: 6

Hello, I have two input files. the first is a master and the second is an alternate. The alternate file can have any number of duplicate records. I need to sort them by the first 10 bytes then merge them.

IN1 = FB, 372bytes
IN2 = FB, 360bytes

key in both files 1:10 bytes

In the master file (IN1), there is data in bytes 360:12 which should be copied to all duplicate records in IN2.

For example.

IN1
0000000001....IND <--- in bytes 360:12
0000000002....-0-
0000000003....IND

IN2
0000000001
0000000001
0000000001
0000000002

DESIRED OUTPUT
0000000001....IND
0000000001....IND
0000000001....IND
0000000001....IND
0000000002....-0-
0000000002....-0-
0000000003....IND

My question is this: How can I sort/merge the two files so that the desired output is obtained? I tried icetool/splice but was unsuccessful.

Any suggestions??

Thanks!

Frank Yaeger · Posted: Wed Apr 05, 2006 4:46 am Post subject:

skodidine · New User Joined: 05 Apr 2006 Posts: 6

Thanks Frank. It worked great. Comparing your icetool/splice with what I had, i see the folly of my ways. I was using the 372byte file first and trying to splice that with the 360byte. I see why you have the 360 first.

Once again, thank you!

Sanjay

Frank Yaeger · Posted: Wed Apr 05, 2006 9:03 pm Post subject:

That's a common mistake. Glad I could help.