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.
Left function
Moderators: chulett, rschirm, roy
Left function
somaraju
Convert the numeric values to VarChar then do a trim to remove leading 0's and then perform your concatenation. Look up the trim() function declaration in the PX manual, I think it is trim(In.Column,"0","F") but I'm not certain and don't have access to the manual here.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>