Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a number in following format: 99265, 13, 123468
I want to load it as a 10 digit string with zero in front. --> 0000099265, 0000000013, 0000123468
My first try would be something like this:
if(len(trim(x))=1; '00000000' & x ;if(len(trim(x))=2; '0000000' & x ;.....
Is there a way to do this smoother than this?
Thanks
Timo
try this : num(x,'0000000000')
try this : num(x,'0000000000')
Thanks for the help! Works perfectly!