|
View previous topic :: View next topic
|
| Author |
Message |
chetanambi
New User
Joined: 21 Jan 2012
Posts: 58
Location: India
|
|
|
|
Hi ,
i have to eliminate duplicates from a file which is of length 100 and format FB by using sort card , below is the criteria to eliminate duplicates.
i have to compare the entire record of the input file with next record (except two fields in between) and duplicates should be written to an output file.
fields to be eliminate SD2E-KEYED-TIME, SD2E-CUST-NO
below is the layout of the input file and out put should be in the same layout.
| Code: |
SD2E-DIV SD2E-BUS-DATE....SD2E-KEYED-TIME....SD2E-CUST-NO....SD2E-DISC-AMT SD2E-DISC-PERCENT
|
|
|
| Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Please provide the details
Atleast , Please provide the details atleast with cols on as you expect too much from others to do it for you
| Code: |
| SD2E-DIV SD2E-BUS-DATE....SD2E-KEYED-TIME....SD2E-CUST-NO....SD2E-DISC-AMT SD2E-DISC-PERCENT |
| Quote: |
| i have to compare the entire record of the input file with next record (except two fields in between) and duplicates should be written to an output file. |
When you say duplicates do you want all records with duplicate key to be written to output or only duplicate records apart from the from for the key to be written to output
Eg
Input
Output
Or
Output
| Code: |
A SECOND REC
A THIRD REC
A FOURTH REC |
Please try to explain better in future as people help in their free time and cant expect them to do everything and feed it for you for free |
|
| Back to top |
|
|
|
|
