Need to add $ and comma in the output file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Need to add $ and comma in the output file

Postby vigneshts1 » Sun Dec 28, 2014 6:04 am

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.
vigneshts1
 
Posts: 6
Joined: Mon Dec 22, 2014 6:10 am
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby BillyBoyo » Sun Dec 28, 2014 3:40 pm

Can you post the sysout from the step you used, and the control cards you used? A sample of the data as well, please.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post