Page 1 of 1

using SQZ justify with outfil trailers

PostPosted: Tue Dec 27, 2016 5:42 pm
by wolfi57
i'm using section trailers3 for summing amount , but now I need to reformat that line to justifying to left and squeeze all spaces du to my edit mask for pd field

it is my actual output
1;2014;1000; 0,00; 1234,55; 0,00;
1;2014;2000; 0,00; 1234,55; 0,00;
1;2015;2000; 0,00; 1234,55; 0,00;
2;2015;2000; 0,00; -1234,55; 0,00;

how to obtain ( csv format to be import in excel )

1;2014;2000;0,00;1234.55;0,00;
1;2014;6000;0,00;1234.55;0,00;
1;2015;6000;0,00;1234,55;0,00;
2;2015;6000;0,00;-1234,55;0,00;

my jcl

OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,11,
TRAILER3=(1,1,C';',2,4,C';',8,4,C';',
TOT=(33,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';',
TOT=(12,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';',
TOT=(54,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';'))

Re: using SQZ justify with outfil trailers

PostPosted: Tue Dec 27, 2016 8:59 pm
by BillyBoyo
Sorry, it won't work.

Why do you "need" it? What part of the world is going to stop revolving if it is not left-justified?

Re: using SQZ justify with outfil trailers

PostPosted: Tue Dec 27, 2016 9:21 pm
by wolfi57
Just wondering, no spécial need, so if its not possible i can deal with

Re: using SQZ justify with outfil trailers

PostPosted: Tue Dec 27, 2016 10:05 pm
by BillyBoyo
OK, so, "now I would like to know if it is possible" rather than "now I need" :-)

Re: using SQZ justify with outfil trailers

PostPosted: Wed Dec 28, 2016 2:32 am
by NicC
And you have not shown any JCL - just sort control cards and they are not JCL.