<div>&nbsp; Probably even better -- didn&#39;t quite get if he was declaring dummy var to field 25 first or what</div>
<div>&nbsp;&nbsp; makes sense though</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 9/14/07, <b class="gmail_sendername">Keith Weatherhead</b> &lt;<a href="mailto:keithw@discusdataltd.net">keithw@discusdataltd.net</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hmmm, maybe...<br><br>cb = mid(25,&quot;1&quot;,&quot;7&quot;)<br><br>Keith<br><br><br><a href="mailto:scooter6@gmail.com">
scooter6@gmail.com</a> wrote:<br>&gt;&nbsp;&nbsp; Wouldn&#39;t just a simple&nbsp;&nbsp;mid&nbsp;&nbsp;statement do the trick?<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;cb=mid(cb,1,3)<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;Scott<br>&gt;<br>&gt;<br>&gt;<br>&gt; On 9/13/07, Steven Waters &lt;<a href="mailto:swaters@triumphinstruments.com">
swaters@triumphinstruments.com</a><br>&gt; &lt;mailto:<a href="mailto:swaters@triumphinstruments.com">swaters@triumphinstruments.com</a>&gt;&gt; wrote:<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; Good Day,<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; I have a Filepro question.<br>
&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; I am trying to strip the decimal out of a number.<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; I have this written;<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; cb(10,.0)=25<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; 25 is (10,.2)<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; if the number for field 25 is 880.88
<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; I get 881 out for dummy cb<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; or if the number is 710.00 I get 710 instead of 71000<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; How do you strip out a numbers decimal and stop the rounding and<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; dropping of<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; the 00
<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; Thanks in advance,<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; Steve<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; _______________________________________________<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; Filepro-list mailing list<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; <a href="mailto:Filepro-list@lists.celestial.com">
Filepro-list@lists.celestial.com</a><br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">
http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>&gt;<br>&gt;<br>&gt;<br>&gt; ------------------------------------------------------------------------<br>&gt;<br>&gt; _______________________________________________
<br>&gt; Filepro-list mailing list<br>&gt; <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>&gt; <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list
</a><br><br>--<br>- - - - - - - - - - - - - - - - - - - - - - - - - - - -<br>Keith F. Weatherhead&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="mailto:keithw@ddltd.com">keithw@ddltd.com</a><br><br>Discus Data, LTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Voice: (815) 237-8467
<br>3465 S Carbon Hill Rd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fax: (815) 237-8641<br>Braceville, IL&nbsp;&nbsp;60407<br><br><a href="http://www.HVACmodel.COM">www.HVACmodel.COM</a>&nbsp;&nbsp;- Equipment Capacity Search Facility<br>- - - - - - - - - - - - - - - - - - - - - - - - - - - -
<br><br><br></blockquote></div><br>