Having problem trying to..

:

: The field is an integer and I want the left hand side padded

: with zeros.

:

: So for example my input in 9723 I want the output

: to be 00009723.

:

print substr("00000000" $1,length($1 " "))

This will create a string with 8 zeros followed by the number ($1),

and take all of the resulting string from the position which is

1 plus the length of the string of the number .

The number of zero's indicate the number of digits in the result.

It doesn't work for a negative number though.

: Could someone please EMAIL me how to do this.

I did, but I thought it'd be nice to post it as well

Have fun,

Jelle Paul

--

+-------------------------------------------------------+

| Vrije Universiteit Amsterdam | |

+-------------------------------------------------------+