<div>
stringVar sTest := &quot;023abc&quot;;<br />
IF Len(sTest) &lt;&nbsp;3 Then &quot;Too Short&quot; Else<br />
(<br />
&nbsp; &nbsp; sTest := LEFT(sTest, 3);<br />
<br />
&nbsp; &nbsp; IF NumericText(sTest) Then <br />
&nbsp; &nbsp; (<br />
&nbsp; &nbsp; &nbsp; &nbsp; IF val(sTest) &lt;&nbsp;100 Then &quot;&nbsp;&quot; &amp;&nbsp;sTest[1] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[2] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[3]<br />
&nbsp; &nbsp; &nbsp; &nbsp; eLSE <br />
&nbsp; &nbsp; &nbsp; &nbsp; sTest[1] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[2] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[3];<br />
&nbsp; &nbsp; )<br />
&nbsp; &nbsp; Else &quot;Not Numric&quot;;<br />
);
</div>


<div>
What does this part of your question mean?<br />
<br />
&gt;&gt;<i>If not a string or less than a 100 use the first concant of values, if greater then 100 then use the second</i><br />
<br />
The final Else in the formula above should be<br />
<br />
ELSE <br />
&nbsp; &nbsp; &nbsp; &nbsp; sTest[1] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[2] &amp;&nbsp;&quot; &quot;&nbsp;&amp; sTest[3];<br />
<br />
mlmcc
</div>


<div>
I have a string as example 110 deg F or could be 70 deg F. &nbsp; <br />
What I need to know if the first three characters is something like &nbsp;(110, or 70&lt;space&gt;) <br />
Then see if the value (which is numeric) is less than 100 (100 deg F) I want to add a space to a set of values I am concanting together at the beginning if less than 100. &nbsp; Its a pretty lineup thing I am trying to accomplish.
</div>


<div>
The text sample you provided indicates you want spaces inserted, but your latest message indicates otherwise. &nbsp;Tough to follow, so please provide a couple of examples of input versus desired output.
</div>


<div>
Try something like<br />
<br />
Local StringVar &nbsp;TestString;<br />
TestString := Left({YourFIeld},3);<br />
<br />
If NumberText(YourString) then<br />
&nbsp; &nbsp; If Val(YourString) &lt;&nbsp;100 then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot; &quot;&nbsp;&amp; TestString<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; TestString<br />
Else<br />
&nbsp; &nbsp; TestString<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
I am a bit out of practice in the use of Crystal and could use a jump start. &nbsp;Been a long time since I wrote crystal formulas and could use help in correcting the code I have attached.<br />
<br />
I need to pull the first three values in a string, determine if the first three values is all numeric and if so is it less then a 100 using a Crystal Formula. &nbsp; If not a string or less than a 100 use the first concant of values, if greater then 100 then use the second.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/03_w12/840182/Quick-Code.txt" target="_blank" class="file-inline" title="Crystal Code Formula (395 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Quick-Code.txt</a>
</div>
</div>


Quick-Code.txt

I am a bit out of practice in the use of Crystal and could use a jump start.  Been a long time since I wrote crystal formulas and could use help in correcting the code I have attached.

I need to pull the first three values in a string, determine if the first three values is all numeric and if so is it less then a 100 using a Crystal Formula.   If not a string or less than a 100 use the first concant of values, if greater then 100 then use the second.

Writing a formula in Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.