PX:Merge records
Posted: Fri Aug 10, 2007 10:55 am
I have input file with CSV file format as shown below
H,1,2....
D,1....
D,2....
H,2,1...
D,1...
Record 1 says its the 1st header record with 2 detail records to follow.
D1,D2 are its coresponding 2 detail records.
Then 4th line is again a header record with 1 details record.
I want the output as
H,1,2...D,1..
H,1,2...D,2..
H,2,1...D,1..
Please help how to achieve this
H,1,2....
D,1....
D,2....
H,2,1...
D,1...
Record 1 says its the 1st header record with 2 detail records to follow.
D1,D2 are its coresponding 2 detail records.
Then 4th line is again a header record with 1 details record.
I want the output as
H,1,2...D,1..
H,1,2...D,2..
H,2,1...D,1..
Please help how to achieve this