Could some one provide me the sort card for below requirement?
The below are the 2 input data sets
Lay out of input file-1
Input file-1 has the key from 1st position to 7th position
Lay out of input file-1I
input file-2 contains one record 3 in consecutive rows (3 rows=1 recorded)
Key starts on 2nd position of first row of the record
Criteria to get the required data
If key matches with input files then I want some numeric data which is there next to next line (last line/3rd row of the record) of file2 from 13th position to 20th position (say FIELD-A), and yesterdays date(mm/dd/yy)
Expected output is
FIELD-A yesterdays date(mm/dd/yy)
Input File-1
----+----1
KEY1111
KEY1111
Input File-2
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
.KEY1111 SOME-1 TEXT..............
SOME-2 TEXT......................
SOME-3 TEXT 11.22.33.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
.KEY1111 SOME-4 TEXT...............
SOME-5 TEXT.............. .
SOME-6 TEXT 44.55.66.
.KEY1111 SOME-1 TEXT..............
SOME-2 TEXT......................
SOME-3 TEXT 11.22.33.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
.KEY1111 SOME-4 TEXT...............
SOME-5 TEXT.............. .
SOME-6 TEXT 44.55.66.
Expected output is
11.22.33 02/14/12
44.55.66 02/14/12
44.55.66 02/14/12