Hi,

Is it possible to add leading zeros to a data field?

I have a list that the customer wants the record's ID number to be 12 digits, and if it's not to ad the correct number of zeros to the beginning to make it so.

So if the record is 1234, they want it to say 000000001234, etc.

Is there any way to do that in an expression? I really do not want to have to go through 3000 records by hand and add them in.

Thanks in advance!

Hi,

Here's how you could do it:

1. In the Variables window, right click and add one variable, let's call it myVar

2. In the expression editor for this variable, write the following expression:

RIGHT("0000000000" & [MyDataField], 10)

where:

"0000000000" is what we want to pad our field with. Here, we've decided to pad with up to 10 zeroes.

[MyDataField] is your data field.

10 is the number of rightmost characters the RIGHT expression will keep.

3. Use @MyVar@ to display the padded value of MyDataField


Hope this helps!