how to fill fields with zeros.

I_Server_Whale · Post by **I_Server_Whale** » Thu Jul 14, 2005 4:44 pm

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.

logic · Post by **logic** » Thu Jul 14, 2005 5:02 pm

"000000000" in transformer derivation of that field..(?)

pnchowdary · Post by **pnchowdary** » Thu Jul 14, 2005 5:10 pm

Alternatively, you can use

Code: Select all

Str("0",10)

in your transformer derivation section.

chulett · Post by **chulett** » Thu Jul 14, 2005 7:47 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 14, 2005 8:50 pm

For example

Code: Select all

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