Substr of Decimal

alisoviejo · Post by **alisoviejo** » Mon Mar 13, 2006 3:14 pm

Hi,
If I have the source as 11.34 I need only the numbers before the decimal, i.e. 11 .

Is there a stage I can use in EE instead of conventionally using the transformer?

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 13, 2006 3:33 pm

Modify stage. Use int32_from_decimal() or int64_from_decimal() function.

alisoviejo · Post by **alisoviejo** » Mon Mar 13, 2006 5:14 pm

Would that round it off or just give the number before the decimal, becasue if it is 11.98 , still we need only 11.

I do not have the access to DS now, will try your idea Ray.

Thanks a bunch.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 13, 2006 5:18 pm

There are optional pieces. You can specify truncation or rounding. It's all in the manual.

Nageshsunkoji · Post by **Nageshsunkoji** » Mon Mar 13, 2006 10:38 pm

Hi,

Use the following rounding function in the transformer. It will give your expected result.

DecimalToDecimal(ColumnName,'round_inf')

Regards
Nagesh.

alisoviejo · Post by **alisoviejo** » Tue Mar 14, 2006 10:51 am

Hi Ray,

I have used

ME_TGT:int64=int64_from_decimal [trunc_zero] (ME_LOW)

ME_TGT:integer=int32_from_decimal [trunc_zero] (ME_LOW)

ME_TGT=int64_from_decimal [trunc_zero] (ME_LOW)

My source column is Real (40.

and my target column is integer(ME_TGT).
The job aborts saying operator conversion not possible, am I missing onthe syntax. Appreciate your time.

alisoviejo · Post by **alisoviejo** » Tue Mar 14, 2006 10:56 am

I got it, I changed the source column type to Decimal and the function works, thanks Ray!

ray.wurlod · Post by **ray.wurlod** » Tue Mar 14, 2006 11:33 am

Real and dfloat are approximate representations of data. Decimal and numeric are exact representations. They are different data types, which is why you experienced what you did. My original response was based on your statement that the data type was Decimal.