concatenate zeros to fields

hargun · Post by **hargun** » Sun Jan 31, 2016 3:36 pm

hi i have input fields like
49456.07

The output i need is
00049456

i tried by using
left('00000000': left(select_stats.TRN_VOLUME_COUNT2,6),8).

Giving me results
00000000

i need 00049456

The length of column is varchar(8))

Can you please help me on this

chulett · Post by **chulett** » Sun Jan 31, 2016 4:22 pm

Is your source field a string or a decimal? Your outer function should be a Right() not a Left(), btw.

ray.wurlod · Post by **ray.wurlod** » Sun Jan 31, 2016 8:28 pm

Code: Select all

Right(Str("0",8):Field(InLink.TheString,".",1,1),8)