Page 1 of 1

Need to add $ and comma in the output file

PostPosted: Sun Dec 28, 2014 6:04 am
by vigneshts1
Hi,

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
----------------------------------------------------------------


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.

Re: Need to add $ and comma in the output file

PostPosted: Sun Dec 28, 2014 3:40 pm
by BillyBoyo
Can you post the sysout from the step you used, and the control cards you used? A sample of the data as well, please.