I'm sure this has to be a very easy question, but unfortunately I'm still struggling with it.
How can I turn this file (Original) : " *VOLUME: AA1A11 TYPE: 3390 UTILIZATION: 99% *FREE* 2 54 55 *FREE* POOLA *FREE* 2 194 195 *FREE* POOLA *FREE* 1 614 614 *FREE* POOLA *VOLUME: BB2B22 TYPE: 3390 UTILIZATION: 73% *FREE* 500 1 500 *FREE* POOLB *FREE* 165 1040 1204 *FREE* POOLB *FREE* 5 1706 1710 *FREE* POOLB " Into this console output (Result) : " AA1A11 3390 2 54 55 POOLA AA1A11 3390 2 194 195 POOLA AA1A11 3390 1 614 614 POOLA BB2B22 3390 500 1 500 POOLB BB2B22 3390 165 1040 1204 POOLB BB2B22 3390 5 1706 1710 POOLB " ....using PIPEs? I know I can use SPECS to rearrange the data in a single record, so getting Result columns 3-6 is easy. The problem I cannot seem to figure out is how to: 1. take the two columns of data from the "*VOLUME:" record then 2. prepend that to the front of each "*FREE*" record , 3. and when next "*VOLUME:" record encountered then use that new data to prepend to the next set of records. I was trying: " 'PIPE (endchar ?) < SOMEFILE MAP A' , '| A: FIND *VOLUME' , '| SPECS W2 1 W4 NW' , '| VAR VOLSER1 TRACK' , '?A:| COPY' , '| COPY' , '| SPECS /'VOLSER1'/ 1 1-* nw' , '| CONSOLE' " ...but it looks like REXX Variable "VOLSER1" is not getting set - instead the PIPE literally prepends the string "VOLSER1" to the front of the records. Any ideas? --Shawn S.
