Changing 4 digits to 8

[samimichaels]

I have a numeric field that currently holds 4 digits but will grow. So I want the 4 digits to have leading zeros. i.e. 4456 to 0004456.

Help.

Thanks

 

[synapsevampire]

This means that you'll convert it to a string:

replicatestring("0", 8 - length(totext({MyTable.MyField},0))) + totext({MyTable.MyField},0)

This doesn't use decimals nor insert thousands separators.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

a simpler way to pad with zeros would be to convert it to a string using this

totext({Table.numberfield},"00000000&quot Jim Broadbent

 

[synapsevampire]

Ahhh, right, good idea, Jim, I think that's the second time you've mentioned that, and I keep doing it the old way....

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

It isn't original....I learned this some time ago from someone here....

That is what I like about this site....you always learn something new....and reinforce things that you may forget. Jim Broadbent