Page 2 of 2

Re: Sum an alphanumeric fields

PostPosted: Tue Jul 08, 2014 8:08 pm
by BillyBoyo
Well, apart from the ".X." left over from the earlier thing you showed, and some subtraction from 10,000 to get the xxxx value, you should be about there.

Re: Sum an alphanumeric fields

PostPosted: Wed Jul 09, 2014 1:10 am
by danylele74
Sorry, but i don't understand you answer.

Re: Sum an alphanumeric fields

PostPosted: Wed Jul 09, 2014 5:23 am
by BillyBoyo
Delete the ",X". Subtract that final value from 10,000, which will give you the remaining length of the record after the field whose sum you want. Replace the xxxx with the result of your calculation. Try it out.

Re: Sum an alphanumeric fields

PostPosted: Wed Jul 09, 2014 3:54 pm
by danylele74
It works !!! Thank you very much.

Here the solution:

SORT FIELDS=(13,9,CH,A),FORMAT=BI                             
OUTFIL REMOVECC,NODETAIL,                                     
SECTIONS=(13,9,                                               
TRAILER3=(1:1,3673,                                           
     TOT=(3674,19,SFF,EDIT=(STTTTTTTTTTTTTTT.TT),SIGNS=(+,-)),
          3693,6307))                                         

Re: Sum an alphanumeric fields

PostPosted: Wed Jul 16, 2014 9:15 pm
by Magesh23586
Why are you sorting with character as well as Binary ?

SORT FIELDS=(13,9,CH,A),FORMAT=BI


Regards
Magesh