Page 1 of 1

how to fill fields with zeros.

Posted: Thu Jul 14, 2005 4:44 pm
by I_Server_Whale
Hi All,


Suppose I have to fill a target field of length 10. How do i fill this field with all zeroes. Any help is appreciated.

Thanks a lot,
naveen.

Posted: Thu Jul 14, 2005 5:02 pm
by logic
"000000000" in transformer derivation of that field..(?)

Posted: Thu Jul 14, 2005 5:10 pm
by pnchowdary
Alternatively, you can use

Code: Select all

Str("0",10)
in your transformer derivation section.

Posted: Thu Jul 14, 2005 7:47 pm
by chulett
And on the chance you meant zero fill (or pad) a field to 10 characters that may have less than 10 characters in it, check out the FMT function.

Posted: Thu Jul 14, 2005 8:50 pm
by ray.wurlod
For example

Code: Select all

Fmt("0", "R%10")