Stop the rounding

Paul McNary pmcnary at cameron.net
Fri Sep 14 12:08:38 PDT 2007


On Friday 14 September 2007 13:55, Bruce Easton wrote:
> Steven Waters wrote Thursday, September 13, 2007 4:07 PM:
> [..]
>
> > I am trying to strip the decimal out of a number.
> > I have this written;
> >
> >
> > if the number for field 25 is 880.88
> > I get 881 out for dummy cb
> > or if the number is 710.00 I get 710 instead of 71000
> >
> > How do you strip out a numbers decimal and stop the rounding and
> > dropping of
> > the 00
>
>  OK - I'm going to try this again - I think I still don't understand
> the problem, plus my previous two replies, I think, were posted in
> the wrong order. :)
>
> Now that I look at your question more, Steve, I'm wondering what exactly
> you're after.  Are you just trying to get the decimal point out and
> leave all the other numbers there even if they don't end in "00",
> or do you really want the last two digits to be "00" and also
> remove the "." but leave the rest of the numbers alone?  I guess it's
> not exactly clear from your subject vs. the things you've tried.
>
> Bruce
>
> Bruce Easton
> STN, Inc.
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list


One solution I use:

Sorry missed one thing
ca(10,.2)=25 - ".50" If you don't want rounded number
cb(10,.0)=ca * "100"   I didn't change 25 to ca here
25 is (10,.2)


Paul McNary
pmcnary at cameron.net


More information about the Filepro-list mailing list