Key is from position (1,13)
It is a Fixed Block file. I need the output as displayed below. I tried to used the SPLICE for the same but since my input can have variable number of key occurances (from 1-20)
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Pandora-Box wrote:
Kolusu,
Why RESIZE is not a better option this case?
You need to read the requirement once again.
purushottam wrote:
Key is from position (1,13)
It is a Fixed Block file. I need the output as displayed below. I tried to used the SPLICE for the same but since my input can have variable number of key occurances (from 1-20)
OP has a multiple keys in his file and for each key can be variable with max of 20 records per key.
ex:
Code:
----+----1----+----2----+----
KEY01 DATA RECORD-01
KEY01 DATA RECORD-02
KEY01 DATA RECORD-03
KEY01 DATA RECORD-04
KEY01 DATA RECORD-05
KEY02 DATA RECORD-AA
KEY02 DATA RECORD-BB
KEY03 DATA RECORD-CC
KEY03 DATA RECORD-DD
KEY03 DATA RECORD-EE
OP wants to club 5 records of KEY01 as a single record, 2 records of Key02 as a single record and 3 records of Key03 as a single record. RESIZE works with fixed number of records for each key. So you need to use splice