Remove comma separator from data
Posted: Thu Aug 18, 2011 1:51 am
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:
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
%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