Page 1 of 1

apend last record in input file but input file have commas

PostPosted: Thu Sep 29, 2016 5:28 pm
by arya_starc
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

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

PostPosted: Thu Sep 29, 2016 5:34 pm
by Aki88
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.

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

PostPosted: Thu Sep 29, 2016 6:35 pm
by arya_starc
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