IBM Mainframe Forum

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';'))

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?

Just wondering, no spécial need, so if its not possible i can deal with

OK, so, "now I would like to know if it is possible" rather than "now I need"

And you have not shown any JCL - just sort control cards and they are not JCL.