Need to put leading zero at right if it is null

vinbhate · Post by **vinbhate** » Thu Jul 24, 2008 12:10 am

Hi All,
I have one requirement if data is
01
1
16
78
4
I need wherever there is 1 or 4 i need to put leading zero in left
it should be
01,01,16,78,04

Can anybody help me with syntax please it will be great help

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 12:57 am

Try

Code: Select all

Fmt(InLink.TheNumber, "R%2")

or

Code: Select all

Fmt(InLink.TheNumber, "R'0'2")

or

Code: Select all

Right("00" : InLink.TheNumber, 2)

just for three.

vinbhate · Post by **vinbhate** » Thu Jul 24, 2008 5:38 am

Thanks Ray!!!!