there is a function to extract only decimal numbers

gorvega79

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

you doesn't need a programm ;-)

Here two, not tested, solutions

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

it work perfectly, thanks so much rené

garak

no problem and welcome