Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I pictured my question (attached).
Well I have a field which has to contain a 12-digit numeric record.
But some of the records are 11-digit .
As you can see on the picture there is "0"-symbol is absent. But I need to add it to the records which 11-digit.
Is it possible? If yes, how can I do this?
Try the following code:
if(len([Field_Name])=11,0&[Field_Name],[Field_Name])
Try the following code:
if(len([Field_Name])=11,0&[Field_Name],[Field_Name])
Hi!
Sorry for late answer,
It's working well. Thanks a lot for your help!))
An alternative solution is to format the field as an 12 digit number. You can try this:
NUM(Field_Name, '000000000000')
If you have trouble interpreting the field as a number then also this could work:
right('0'&Field_Name, 12)