I have a question regarding varchar to decimal conversion
I have 3 decimal fields in the target table. I'm extracting all these three decimal values from input VarChar field.
Input values:
InpCol1 -23.765980
InpCol2 - 47.987650
InpCol3 - 2101.00000
I'm using the following derivations in transformer
Code: Select all
StringToDecimal(Field(lnkinpData.ProdPriceX,',',1))
Code: Select all
StringToDecimal(Field(lnkinpData.ProdPriceY,',',2))
Code: Select all
StringToDecimal(Field(lnkinpData.ProdPriceZ,',',3))
.000000000 Decimal[9,9]
.000000000 Decimal[9,9]
00002101.00000 Decimal[13,5]
I searched this forum and tried using Double instead of Decimal. However I got all three output values as .000000. I'm trying to extract the exact input decimal values (23.765980, 47.987650, 2101.00000...)
Kindly let me know your idea on this.
Many thanks and Kind Regards