View previous topic :: View next topic
|
Author |
Message |
gprerna
New User
Joined: 21 Mar 2007 Posts: 38 Location: US
|
|
|
|
Hi,
I want to prepend zeroes before a number whose sarting position is unknown. For example in the attached document, we have the number 17.13 starting from column 9. But this number can be of variable bytes. In case, its 7.13 then it will start from column 10. Please suggest how i can prepend zeroes before this number. I want to take average of these numbers from 3 different files. |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
I guess with SORT you can change spaces to Zeros using ALTSEQ.
And then use the numeric data.
Try if this works. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
gprerna,
How many zeros to you want to prepend? What do you want the output to look like for 17.13, for 7.13, for 217.13?
Why do you need to prepend zeros to get an average? |
|
Back to top |
|
|
|