Talend community forum / Integer part of a decimal

louisdeg · 2012-06-14 10:50:53

Hello,

I want to get the integer part of a decimal number (double) in a Tmap. Is it possible?

ex : 8,3-->8
8,9-->8

Thank you..
Louis

avdbrink · 2012-06-14 12:49:33

Hi,

You can use: Integer.valueOf(String.valueOf((long) 8.3d)) to map a double to an Integer

Regards,
Arno

louisdeg · 2012-06-14 14:36:53

I misspoke, I want to get the integer part of the calculation result.

(Tab1.VAL_MES -Tab2.VAL_ENG)<0 ? Mathematical.ABS(Tab1.VAL_MES-Tab2.VAL_ENG) : 0

and i want the integer part of : Mathematical.ABS(Tab1.VAL_MES-Tab2.VAL_ENG)

Thank you a lot..
Louis

avdbrink · 2012-06-14 14:40:10

Hi,

Isn't Integer.valueOf(String.valueOf((long)Mathematical.ABS(Tab1.VAL_MES-Tab2.VAL_ENG))) working for you then?

Regards,
Arno

louisdeg · 2012-06-15 12:20:21

Yes !! it's Ok...
thank you arno...

Louis

kzone · 2012-06-17 14:16:36

hi,

put the precision to '0' in your metadata ... it should work !
regards

laurent

Announcement

Unanswered posts

#1 2012-06-14 10:50:53

Integer part of a decimal

#2 2012-06-14 12:49:33

Re: Integer part of a decimal

#3 2012-06-14 14:36:53

Re: Integer part of a decimal

#4 2012-06-14 14:40:10

Re: Integer part of a decimal

#5 2012-06-15 12:20:21

Re: Integer part of a decimal

#6 2012-06-17 14:16:36

Re: Integer part of a decimal

Board footer