View previous topic :: View next topic |
Author |
Message |
manojvoona Beginner
Joined: 05 Jan 2006 Posts: 43 Topics: 14
|
Posted: Wed Jun 13, 2007 3:00 pm Post subject: Pad zeroes to left justified numeric data |
|
|
Hi,
I am sorry if some one has asked you the same questions. I Could not fine in the forum.
Here is my questions
I have a file with account number 12 digits. But the number is left indented, that is for example Code: |
Ac #
20
20000
200000
123456789111
|
Now i want to convert it to Code: |
000000000020
000000020000
000000200000
123456789111
|
Only Syncsort is installed in our Mainframes.
help in this regards is higly appreciated.
Thanks
Manoj Voona |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Wed Jun 13, 2007 3:13 pm Post subject: |
|
|
Manoj,
You have been in this board for more than a year and you must have seen Kolusu Requesting/Shouting - to use meaningful topics. Using the forum name "Sort" or "Sort Help" is not a meaningful topic and will be of no use for others who search for similar queries in future.
The answer to your query is available here (Change PGM=ICETOOL to PGM=SYNCTOOL for syncsort)
http://www.mvsforums.com/helpboards/viewtopic.php?t=3173&highlight=sort+justify
Thanks,
Phantom |
|
Back to top |
|
|
manojvoona Beginner
Joined: 05 Jan 2006 Posts: 43 Topics: 14
|
Posted: Wed Jun 13, 2007 3:22 pm Post subject: |
|
|
Sorry Phantom,
thanks for the help !!!!! |
|
Back to top |
|
|
CICS Guy Intermediate
Joined: 30 Apr 2007 Posts: 292 Topics: 3
|
Posted: Wed Jun 13, 2007 3:26 pm Post subject: |
|
|
You should be able to use the UFF format:
Unsigned free format. Decimal digits (0-9) are extracted from right
to left to form a number value. All non-decimal digit values in the
field are ignored. A maximum of 31 digits can be provided. When
more than 31 digits are found in the field, the leftmost digits will be
ignored. |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Wed Jun 13, 2007 3:32 pm Post subject: |
|
|
Manoj,
UFF requires the latest version of Syncsort (v 1.2 and above). What version of syncsort are you using ?
Thanks,
Phantom |
|
Back to top |
|
|
manojvoona Beginner
Joined: 05 Jan 2006 Posts: 43 Topics: 14
|
Posted: Mon Jun 18, 2007 3:05 pm Post subject: |
|
|
thanks for all,
The UFF format worked.
Thanks
Manoj Voona |
|
Back to top |
|
|
|
|