DSXchange

Hi,

I am getting the data like 80.123,23.123
means after decimal point i am getting 3 digits ,i need to multiply the data and get the results up to 3 decimal point only(121.122).
source is text file here.
do we have any functions for this transformer..

Please let me know..

Sorry but I can't make any sense out of your question. Can you provide some actual data examples (rather than made up ones) and then the results you need to get from that data? Perhaps then someone can help you get there. Might also help if you exanded on what "multiply the data" means.

What happens if you convert each field to decimal using StringToDecimal() function then multiply the two together into an output field that has a scale of 3?