decimal field problem

shihaj · Post by **shihaj** » Wed Jan 10, 2007 6:13 am

i have a decimal field in a file, to which data is loaded as 00000.0, instead of 0.0, for an input 000000. Even after i do a trimming on 0s, the problem is not solved.

Intially the input is char and i am converting it to decimal using string to decimal and i get this - 00000.0 (for 5,1) and again loading into a char field in the xml, which is loaded as 00000.0.

can anyone tell me how to remove the leading zeros from this?

DSguru2B · Post by **DSguru2B** » Wed Jan 10, 2007 7:52 am

Welcome Aboard
It is doing what you asked it to do. Converting it to Decimal(5,1). What is the datatype of this particular column, as defined in your output link. What is your output , is it a flat file or database?

vij · Post by **vij** » Wed Jan 10, 2007 8:23 am

DSguru2B wrote:Welcome Aboard
It is doing what you asked it to do. Converting it to Decimal(5,1). What is the datatype of this particular column, as defined in your output link. What is your output , is it a flat file or database?

thanks for ur reply.

this is wat has to be achieved:

A column (string 6) wth value for eg., 000000 from a dataset needs to be loaded into xml with decimal (5,1), as using a decimal in xml didnt give favorable output, it was being used as a char of lenght 10 and we faced the abbove said problem...

pls help in solving the problem

I_Server_Whale · Post by **I_Server_Whale** » Wed Jan 10, 2007 12:07 pm

vij wrote:
thanks for ur reply.

this is wat has to be achieved:

A column (string 6) wth value for eg., 000000 from a dataset needs to be loaded into xml with decimal (5,1), as using a decimal in xml didnt give favorable output, it was being used as a char of lenght 10 and we faced the abbove said problem...

pls help in solving the problem

ur, wat, lenght,abbove and pls do NOT belong to the english language. And hence makes it difficult to understand your posts. Can you please correct/edit your post?

There is always the 'preview' button to check for misspells or typos or format issues. Use it.

Thanks,
Whale.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 10, 2007 2:32 pm

Search would have revealed to you that Decimal data are always displayed with leading an trailing non-significant zeroes, so that you can be sure that precision and scale are working correctly, and so that they can correctly populate fixed-width format files. Such decimal values can correctly be loaded into database tables.

So why do you want to remove the leading zeroes? It's not necessary.

If you want to persist, convert to VarChar() and trim from there. You can do this with a Modify stage or with a Transformer stage.