DSXchange

Posted: **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

Posted: **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.

Posted: **Sun Jan 31, 2016 8:28 pm**

Code: Select all

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

DSXchange

concatenate zeros to fields

concatenate zeros to fields