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.5SET 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 <!-- #yiv5481764781 _filtered {} _filtered {} _filtered {} #yiv5481764781 #yiv5481764781 p.yiv5481764781MsoNormal, #yiv5481764781 li.yiv5481764781MsoNormal, #yiv5481764781 div.yiv5481764781MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";} #yiv5481764781 a:link, #yiv5481764781 span.yiv5481764781MsoHyperlink {color:blue;text-decoration:underline;} #yiv5481764781 a:visited, #yiv5481764781 span.yiv5481764781MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv5481764781 p.yiv5481764781MsoAcetate, #yiv5481764781 li.yiv5481764781MsoAcetate, #yiv5481764781 div.yiv5481764781MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";} #yiv5481764781 span.yiv5481764781EmailStyle17 {font-family:"Times New Roman", "serif";color:windowtext;font-weight:normal;font-style:normal;} #yiv5481764781 span.yiv5481764781BalloonTextChar {font-family:"Tahoma", "sans-serif";} #yiv5481764781 .yiv5481764781MsoChpDefault {} _filtered {} #yiv5481764781 div.yiv5481764781WordSection1 {} -->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 -- 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.
