Using the vdouble SET VAR vsomething int = (sloc(ctxt(.vdouble)),’.’,0)
If vsomething is not 0 then it found the decimal I’m doing this from my phone and memory. Buddy Sent from my iPhone > On Mar 17, 2020, at 10:13 AM, 'Karen Tellef' via RBASE-L > <[email protected]> wrote: > > > Admittedly this is a bit of a kluge, not sure if there's a better way (if > someone comes up with something, then it goes into my notes!) > > First I test whether the number has a decimal or not: > > SET VAR vDouble DOUBLE = 10.5 > SET VAR vMod INT = (MOD(.vDouble,1)) > IF vMod = 0 THEN > -- it has no decimal > ELSE > > -- it has a decimal. So do a CTXT of the variable, use SLOC to find the > decimal place, then extract characters after the decimal > > ENDIF > > > Any better ideas? > > Karen > > > -----Original Message----- > From: Jim Belisle <[email protected]> > To: [email protected] <[email protected]> > Sent: Tue, Mar 17, 2020 9:03 am > Subject: [RBASE-L] - capture just the decimal > > What is the function or combination of functions that will give me just to > decimal portion of a numeric number? > I want to use the decimal portion to determine my next action. > > James Belisle > > Making Information Systems People Friendly Since 1990 > <image001.jpg> > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047ED5091A4C04CE8BE2AF4A0F60%40CH2PR02MB7047.namprd02.prod.outlook.com. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/2110613929.7028313.1584454387391%40mail.yahoo.com. > <image001.jpg> -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/F67D243A-07E5-4B4B-953B-554623C345FD%40comcast.net.
