Combine two files

aniceg · New User Joined: 04 Apr 2008 Posts: 8 Location: chennai

I have a file with the following fields. The record length is 50
Name(10) address(10) Rollno(10) seqno(10) age(10)
Ash Mumbai 89 78 18
Priya Chennai 56 58 23
Gayathri Madurai 29 69 19
Sathya Madurai 88 59 21

There is another file with the following fields. The record length is 40
Name(10) address(10) Rollno(10) age(10)
Ash Mumbai 89 18
Priya Chennai 56 23
Gayathri Madurai 29 19

based on the comparison of these two files the third file should be created which contains those records for which the roll no matches and the third file should contain seq no included at the end of the file .Record length of third file is 50

Frank Yaeger · Posted: Fri Jul 11, 2008 8:51 pm Post subject:

Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed the output could be sorted by the rollno. If you want the output sorted in some other way (e.g in the original order of the file1 or file2 records), let me know.