Page 1 of 1

FMT function in parallel transfer

Posted: Tue Aug 23, 2005 11:13 am
by pongal
Hi,
i wanted the exact parallel function to format a value.
eg:- i need to generate a 6 digit number like
FMT(@OUTROWNUM,"6''0'R")
"000001"
"000002"

FMT does not work on parallel transformer and i should not use Basic transformer here for this formatting.

is there any parallel function which takes care padding zero's on the left side of the value?

Posted: Tue Aug 23, 2005 11:55 am
by Sainath.Srinivasan
Right(PadString("","0", length) : Trim(YourValue), length)