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?
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)
View solution in original post
yes it works.