Page 1 of 1

Remove comma separator from data

PostPosted: Thu Aug 18, 2011 1:51 am
by MitchellSTL
I have a numeric field from a PC CSV file. The numeric is in the format of "1,234 ". The field is 10 positions and left justified. I need it right justified with leading zeros and no comma separator. My command on my "BUILD" is this:

%08,JFY=(SHIFT=RIGHT,LEAD=C'0000000000'),


My desired out put is: 0000001234

I saw that there is a way to ADD comma separators using an EDIT= parm, but did not see a way to remove them. Is there any way to get this accomplished in sort? If not, I'm not totally opposed to using another tool like FileManager. Just trying to get it done in one step.

We are using Z/OS DFSORT V1R12.

TIA,
Mark Mitchell

Re: Remove comma separator from data

PostPosted: Thu Aug 18, 2011 2:45 am
by Frank Yaeger
You can use:

UFF,EDIT=(TTTTTTTTTT)

instead of JFY.

Re: Remove comma separator from data

PostPosted: Thu Aug 18, 2011 5:37 am
by MitchellSTL
Thank you for your quick response! That's exactly what I needed! I appreciate your help!