Decimal issue

dodda · Post by **dodda** » Thu Apr 30, 2009 1:50 pm

Hello

I have a requirement where i need to read the file and produce the XML. I have seqential file stage as source transfomer in between and XML output stage as target.
I am trying to read the data out of the file for a field called A as decimal(7,2) and in the transfomer i am mapping to a Field called A again as decimal (7,2) to XML stage

My requirement is if i have 0000200 as the value of Field A from the input file i need to output 00002.00 but where as i am outputting only 2.
I want the zeros to be in the output XML as well.

If i have some thing like 1234567 from the input file for filed A then i am getting 12345.67 in the XML
Is there a way that this can be done.

Thanks

Kryt0n · Post by **Kryt0n** » Thu Apr 30, 2009 5:06 pm

Don't use decimal, have field as a string (unless that will cause quotes around the output?)