<div>
Which version of crystal reports?<br />
<br />
You could look at Rtrim/Ltrim<br />
<br />
<a href="https://www.crystalreportsonlinetraining.com/dl/Crystal-String-Functions.pdf" rel="ugc">Try string Functions</a>
</div>


<div>
If it always a number you can use VAL to get the value.<br><br>Use a formula<br>Left({YourField}, InStr({YourField, ' ')-1)<br><br>mlmcc
</div>


<div>
Try using rtrim(string) and see what you get.<br />
You can use split on space and get the first element of the array.<br />
You could use substring..<br />
<br />
You could add this to the SQL query using SQL related <br />
<br />
Using substring charindex or rtrim <br />
<br />
The field is being used for sonething else,that you need to convert it to a datatype?
</div>


zachvaldez

<div>
&nbsp;To add to Ido's suggestion, if the field could every be empty (no characters at all, including spaces), the Split function would give you an empty array, and you'd get a subscript error. &nbsp;You can use the Length function to avoid that:<br><br><pre><code class="code-1 nolinks" id="code-20-43302835-1"><span>if Length ({your_field}) &gt; 0 then</span>
<span>&nbsp; Split({your_field}, " ")[1]</span>
<span>else</span>
<span>&nbsp; ""</span>
<span></span>
</code></pre>&nbsp;James
</div>


<div>
Actually, James suggestion would fail to handle a case where the field has no spaces.<br>So here's a solution that handles such cases:<br><br><pre><code class="code-1 nolinks" id="code-20-43302878-1"><span>local stringvar array myArray := Split({your text field}, " ");</span>
<span>If UBound(myArray) &gt; 0 Then</span>
<span>myArray[1]</span>
<span>ELSE</span>
<span>myArray[0];</span>
</code></pre>
</div>


<div>
&nbsp;No, it's fine. &nbsp;If there are no spaces, Split will just give you an array with one element that contains the string (eg. Split ("a", " ") [1] will give you "a"). &nbsp;If you wanted the 2nd or later elements, then you could use UBound to make sure that the array had that many elements.<br><br>&nbsp;Also, there is no 0 element in CR arrays, so your myArray[0] would give you an error.<br><br>&nbsp;James<br><br>
</div>


<div>
Because we are going after the 1st (or only) element, James is right.
</div>


<div>
<div class="content wysiwyg-content">
how to extract data before the first blank or space?<br />
6666 OP<br />
64 hhh<br />
in this example, return 6666 . or. 66 in the other one
</div>
</div>


how to extract data before the first blank or space?
6666 OP
64 hhh
in this example, return 6666 . or. 66 in the other one

Parsing in Crystal Report

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.