Remove comma separator from data



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Remove comma separator from data

Postby MitchellSTL » 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:

%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
MitchellSTL
 
Posts: 27
Joined: Wed Feb 16, 2011 8:57 am
Has thanked: 1 time
Been thanked: 0 time

Re: Remove comma separator from data

 

Re: Remove comma separator from data

Postby Frank Yaeger » Thu Aug 18, 2011 2:45 am

You can use:

UFF,EDIT=(TTTTTTTTTT)

instead of JFY.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Remove comma separator from data

Postby MitchellSTL » Thu Aug 18, 2011 5:37 am

Thank you for your quick response! That's exactly what I needed! I appreciate your help!
MitchellSTL
 
Posts: 27
Joined: Wed Feb 16, 2011 8:57 am
Has thanked: 1 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post