apend last record in input file but input file have commas



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

apend last record in input file but input file have commas

Postby arya_starc » Thu Sep 29, 2016 5:28 pm

Hi All,

I have input file like this
SORTIN FILE

=COLS> ----+----1----+----2----+----3----+
01/07/2016 400,536   8,488,080,000
02/07/2016 500,001   5,123,070,000
.
.
.
.
.
 

SORTOUT FILE

TOTAL    3,337,635  52,125,186,000
 


the value '3,337,635' & '52,125,186,000' comes as the sum of fields from (11:9) and (20:16)

Is it possible to taken the values with commas in the sort input
arya_starc
 
Posts: 60
Joined: Mon Sep 21, 2015 1:39 pm
Has thanked: 3 times
Been thanked: 0 time

Re: apend last record in input file but input file have commas

 

Re: apend last record in input file but input file have comm

Postby Aki88 » Thu Sep 29, 2016 5:34 pm

Use TRAILER1 to build the TOTALs records; instead of the ZD for numbers, use SFF (Signed Free-Form) or UFF (Unsigned Free-Form), depending on your need.

Before you tread any further, would recommed you visit this link and understand the different data formats, so that you know what you're getting into.

Hope this helps.

These users thanked the author Aki88 for the post:
arya_starc (Thu Sep 29, 2016 6:35 pm)
Aki88
 
Posts: 286
Joined: Tue Jan 28, 2014 1:52 pm
Has thanked: 31 times
Been thanked: 23 times

Re: apend last record in input file but input file have comm

Postby arya_starc » Thu Sep 29, 2016 6:35 pm

Aki88 wrote:Use TRAILER1 to build the TOTALs records; instead of the ZD for numbers, use SFF (Signed Free-Form) or UFF (Unsigned Free-Form), depending on your need.

Before you tread any further, would recommed you visit this link and understand the different data formats, so that you know what you're getting into.

Hope this helps.


THANKS..yes I am getting the desired output.
it is very helpful
arya_starc
 
Posts: 60
Joined: Mon Sep 21, 2015 1:39 pm
Has thanked: 3 times
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post