Left function
Posted: Wed Apr 12, 2006 3:08 pm
Hi,
I have a requirement like this . I have a field1 and field2 with decimal(7,4) in DB2 table for example if have a value of field1 as 001.2000 and 001.4000. I need output as 1.20001.4000 and I am using in transformer left (field1,eight):left(field2,eight) but iam getting output as 001.200 001.400 how to eliminate the zeros before numeric values and how toget the other Zero after decimal the output I want is Char .
THe final output must be 1.2000 1.4000
Thanks,
Somaraju.
I have a requirement like this . I have a field1 and field2 with decimal(7,4) in DB2 table for example if have a value of field1 as 001.2000 and 001.4000. I need output as 1.20001.4000 and I am using in transformer left (field1,eight):left(field2,eight) but iam getting output as 001.200 001.400 how to eliminate the zeros before numeric values and how toget the other Zero after decimal the output I want is Char .
THe final output must be 1.2000 1.4000
Thanks,
Somaraju.