How to convert the value '1' into the format '000001' ?

[cheburashka]

Hello,

I want to create a new field "A" with the values '2012000001, 2012000002,...,  2012000011,'.

These values are created from the values of the fields "number" = '1,2,3,4,...' and "year" = 2012,2013,2014.

How do I create the field A in the script?

How to convert the value '1' to '000001' ?

, Thanks for your input, Koen

[swuehl · Accepted solution]

=num(1,'000000')

or in your script

LOAD

     year,

     number,

     num#(year & num(number, '000000')) as A,

     ...

[MayilVahanan]

Hi

Try like this

=Num(1,'000000')