View previous topic :: View next topic
|
Author |
Message |
harsha puthraya
New User
Joined: 29 Oct 2008 Posts: 8 Location: Bangalore
|
|
|
|
Hi,
Is it possible to Left Pad a field with ZEROS using SORT?
My requirement is as below
MY INPUT
Code: |
NAME MARKS
============
DANNY 55
TOM 60
MICK 6
HARSHA 30
VARUN 50
|
EXPECTED OUTPUT
Code: |
NAME MARKS
============
DANNY 055
TOM 060
MICK 006
HARSHA 030
VARUN 050
|
Can you please help me with it?
Thanks!
Harsha |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Below step will give you desired result...
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
DANNY 55
TOM 60
MICK 6
HARSHA30
VARUN 50
VARUN 125
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC OVERLAY=(7:7,3,UFF,EDIT=(TTT))
/*
|
Output will be
Code: |
DANNY 055
TOM 060
MICK 006
HARSHA030
VARUN 050
VARUN 125
|
|
|
Back to top |
|
|
harsha puthraya
New User
Joined: 29 Oct 2008 Posts: 8 Location: Bangalore
|
|
|
|
Thanks a lot for your suggestion!!
Regards
Harsha |
|
Back to top |
|
|
|