Passing data through records

spradeepece · New User Joined: 25 Jun 2008 Posts: 19 Location: Chennai

Hi,

Is is possible to carry over values from previous record to current record, using Sort? For example, I have a condition where based on a field value, another field in previous record should be copied to the current record.

For instance, if column 5 in the input file reads 'R', data in column 1 to 3 should be carried over to the next line.

Input File (FB/5)

Escapa · Posted: Mon May 03, 2010 3:42 pm

Just a bit of confusion....

for first case ...AAA is carried over and not 123

But in second case...DDD(char associated with R) is carried over

spradeepece · New User Joined: 25 Jun 2008 Posts: 19 Location: Chennai

Yes.

For 123, the previous record - AAA is carried over. For the third record (spaces) AAA will 'NOW' be the previous record. Hence AAA is carried over.

DDD in input file is not associated with R. Here again, 'EEE' and 'Spaces' were 'Overlayed' with the 'DDD'.

In other words.. Until the next occurence of non-R character (here Space) in Column 5, the data (with a non-R character in Column 5) should be repeated.

Thanks..

Escapa · Posted: Mon May 03, 2010 6:50 pm

Sorry.. I think, I confused you.. .
Here is DFSORT sortstep will give you desired result

spradeepece · New User Joined: 25 Jun 2008 Posts: 19 Location: Chennai

Thanks a lot Sambhaji,

This was perfect..

Escapa · Posted: Mon May 03, 2010 9:55 pm

Frank Yaeger · Posted: Mon May 03, 2010 11:06 pm

sambhaji,

Just curious - why did you use both INREC and OUTFIL when you could just use INREC?

Escapa · Posted: Mon May 03, 2010 11:14 pm