extend a field value

[Oti47]

hello,
i want to extend a number field to a defined length like:

1324 to 001234
45678 to 045678

How could i do that on a simple way?

Thanks

[Oti47]

Hi,
yes it works.

Thanks

[kristian_kolb · Accepted solution]

Assuming that you have a field num_field that needs to be zero-padded into 6 characters, and that the value of the field does not exceed 999999;

eval num_field = "000000" . num_field | eval num_field = substr(num_field, -6)

/K