there is a function to extract only decimal numbers

gorvega79 · **Posted:** Fri Jul 17, 2009 9:46 am

Hi
i want to extract from an amount only the numbers after decimal point, there´s a function or i have to do a little program to do this. thanks

garak · **Posted:** Fri Jul 17, 2009 9:56 am

you doesn't need a programm ;-)

Here two, not tested, solutions

Quote:

Name DataType Subtype Length
X Decimal
Y Text 2
I Decimal
Z INTEGER

X := 2368.12; //the dot (.) could also be a comma (,). It's depend. on your local language settings
Y := copystr(format(x),Strpos(format(x),'.')+1,2); //12

I := x mod 1; //0.12
Z := x mod 1 * 100; //12

Regards

gorvega79 · **Posted:** Fri Jul 17, 2009 10:03 am

it work perfectly, thanks so much rené

garak · **Posted:** Fri Jul 17, 2009 10:48 am

no problem and welcome

mibuso.com

there is a function to extract only decimal numbers

Who is online