|
View previous topic :: :: View next topic
|
| Author |
Message |
raviprabhu
New User
Joined: 20 Oct 2006
Posts: 29
|
|
|
|
Hi,
I have 2 input files with same record length (480)
I want to match the key (starting from 7 to length 17) if there is a match found in both input files then write to output file. |
|
| Back to top |
|
 |
raviprabhu
New User
Joined: 20 Oct 2006
Posts: 29
|
|
|
|
| The input file contains duplicate records |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19251
Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you read about JOINKEYS.
In addition to the sort documentation, there are many examples here in the forum. Use the SEARCH to find them. |
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
You can use DFSORT's JOINKEYS function for that. For some examples, see the "Create files with matching and non-matching records" Smart DFSORT Trick at:
Use [URL] BBCode for Links |
|
| Back to top |
|
|
|
|
