Add Digits to a set Length 2

[rwn]

I have a formula @PartNumber which is (Job.PartNumber) and if the Part Number is less than 15 digits, I need to add as a prefix Zero's.

For example, the Part Number is: 1480-7865-01. This is 12 digits in length. So 3 Zero's must be added and show as follows: 0001480-7865-01.

Can this be done? Thank you!

 

[lbass]

stringvar x := {table.field};
if len(x)<15 then
replicatestring("0",15-len(x))+x else
x

-LB

 

[crystalkiwibruce]

ToText({table.partnumber},"000000000000000")

Should work best.

 

[rwn]

ToText({Job.Part_Number},"000000000000000")
This formula exhibits an error: To many arguments have been given.

 

[lbass]

That's because it is already a string. Did you try my suggestion?

-LB

 

[lbass]

Oh, I guess you did.

-LB

 

[crystalkiwibruce]

My formula works if the field is numeric. Sorry for the error with your string field.

 

[rwn]

It's alpha mimetic. But thank you, I can use for the future.