Loop until len(trim()) = x

[Anonymous]

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

[jaumecf23 · Accepted solution]

try this : num(x,'0000000000')

[Anonymous]

Thanks for the help! Works perfectly!