> -----Original Message-----
> From: IBM Mainframe Discussion List On Behalf Of tony babonas
> 
> There's a crude way to do this by aligning the data in a 
> series of temp files, i.e. 
> 
> OUTREC OUTFIL=OUT1,
>        INCLUDE=(8,3,CH,EQ,C'99~'),           WHEN COL 8 IS 
> THE DESIRED 99~
>        OUTREC=(11,5)                         numeric data 
> following the ~
> 
> repeat this block of lines for every mutation of where ~ 
> occurs.  write an additional OUTFIL for each mutation.  then 
> concat each file into a SUM step.
> 
> Hey, the price is right......

But you'd "lose" any and all records with a price field that doesn't end in
'99~'....

    -jc-

[ snip ]
> > I have a requirement which states like this:
> > 
> > Given records like
> > 
> > 1~ABC~99.99~12345
> > 123~AB~9.99~567
> > 34~c~1.99~345
> > 
> > where there are 4 fields in each record, each separated by 
> a '~'. The 
> > third field is the price field, which i need to sum up. ...

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Reply via email to