Adding Leading Zeroes To A String 1

[brendalanigan]

This should be a straightforward enough question but I am having some problems resolving it.

I have a string value which contains numbers which I need to pad with leading zeroes if the number is less than 4 digits in length i.e if the value has 1 digit it needs 3 leading zeroes and if it is 2 digits it needs 2 leading zeroes.

What is the best way to go about this?

Many thanks.

 

[lbass]

Try:

totext(val({table.string}),"0000")

-LB

 

[IdoMillet]

or Right("0000" + {table.string}, 4)

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[brendalanigan]

That worked perfectly, thank you!