Stop the rounding
Bruce Easton
bruce at stn.com
Fri Sep 14 11:36:14 PDT 2007
scooter6 at gmail.com wrote Friday, September 14, 2007 2:10 PM:
-----------------------------------
-----------------------------------
To: Steven Waters
Cc: Filepro List
Subject: Re: Stop the rounding
Wouldn't just a simple mid statement do the trick?
cb=mid(cb,1,3)
Scott
-----------------------------------
-----------------------------------
On 9/13/07, Steven Waters <swaters at triumphinstruments.com> wrote:
------------------------------
Good Day,
I have a Filepro question.
I am trying to strip the decimal out of a number.
I have this written;
cb(10,.0)=25
25 is (10,.2)
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
Thanks in advance,
Steve
-----------------------------
Yes, but only will work if your numbers are always
the same length.
Check out the floor and int functions -
floor(expression) returns the next less int. w/
same length, edit as expression whereas
int(n) return the integer portion of a number.
Bruce
Bruce Easton
STN, Inc.
More information about the Filepro-list
mailing list