I have the output file in the following format,
** GOODS REPORT **
----------------------------------------------------------------
** CCCCC **
----------------------------------------------------------------
ABCD $ 15478123190
XXXX $ 18923410
----------------------------------------------------------------
ABCD # 9001214
XXXX # 1234
----------------------------------------------------------------
** ZZZZZ **
----------------------------------------------------------------
ABCD $ 12100123190
XXXX $ 2118923410
----------------------------------------------------------------
ABCD # 159001214
XXXX # 121234
----------------------------------------------------------------
----------------------------------------------------------------
** CCCCC **
----------------------------------------------------------------
ABCD $ 15478123190
XXXX $ 18923410
----------------------------------------------------------------
ABCD # 9001214
XXXX # 1234
----------------------------------------------------------------
** ZZZZZ **
----------------------------------------------------------------
ABCD $ 12100123190
XXXX $ 2118923410
----------------------------------------------------------------
ABCD # 159001214
XXXX # 121234
----------------------------------------------------------------
In the above output file,i want to produce ($$$,$$$,$$$,$$9.99) for the $s value and (ZZZ,ZZZ,ZZ9) for the # values. I tried OUTREC IFTHEN with WHEN with some expression and build it using BUILD EDIT=($II,III,III,IIT.TT) for $ and # values..But my bad luck that is not available in my shop.
Can anyone help me to achieve this in any other way.?
Thanks,
vs.