View previous topic :: View next topic
|
Author |
Message |
Rupa.P.V Warnings : 1 New User
Joined: 04 Jul 2006 Posts: 30
|
|
|
|
Hi All,
My input file is in the format given below.
P123CLOT 0
P123CLOT 1000
P123CLOT 200
P123CLOT 10
the second column in the above file need to be summed up...
when i use the
Sum fileds =(26,4,ZD).
I am getting the output in the Hexa decimal format.
Please help me out to get it n the normal format.
If i am not clear with my question please let me know.
Thanks in advance.. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Well, you haven't explained things very clearly, but based on experience I'm going to take a guess that your summed ZD field looks like this
121{
instead of
1210
If that's the case, you can use the following DFSORT control statement to get 0 (X'F0' - F sign) instead of { (X'C0' - C sign):
If that's not it, then you need to explain more clearly what your input looks like (use vb code tags, or b for each blank), what your output looks like, and what you want your output to look like. |
|
Back to top |
|
|
Rupa.P.V Warnings : 1 New User
Joined: 04 Jul 2006 Posts: 30
|
|
|
|
Yes Frank,
I was getting the output as 121{ and i wanted it as 1210.
I used the statament which u have given and its working now ....
Thanks a lot Frank.....
It helped me a lot... |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Glad I could help. |
|
Back to top |
|
|
|