<div>
Agree. It is not clear what you want done.<br />
<br />
mlmcc
</div>


Agree. It is not clear what you want done.

mlmcc

<div>
I am sorry gentlemen I really am trying to get better about creating a question. never was that good at Jeopardy. My brother was. Seems that gene missed me altogether. I understood the formula that I had at the top given by an EE member. I was trying to have it look at the value created by my formula at top and have it pluck out the value if the unit of measure was in &quot;inches =in&quot; or in &quot;feet = ft&quot;. I was not sure how to do that. Thanks for the input. 
</div>


I am sorry gentlemen I really am trying to get better about creating a question. never was that good at Jeopardy. My brother was. Seems that gene missed me altogether. I understood the formula that I had at the top given by an EE member. I was trying to have it look at the value created by my formula at top and have it pluck out the value if the unit of measure was in "inches =in" or in "feet = ft". I was not sure how to do that. Thanks for the input.

<div>
<div class="content wysiwyg-content">
I have a formula that works perfect for finding a value in a string field. How can I expand on that <br />
and actually pull and print out either a value of &nbsp; &nbsp;&quot;ft&quot; or &quot;in&quot; . Currently the formula pulls out everything like &quot;12 ft&quot; or &quot;24 in&quot; I need to use this formula in some capacity then expand on it.<br />
<br />
local stringvar array strArray := split({InvoiceLine.Invoice<wbr />LineDesc},<wbr />&quot;,&quot;);<br />
if ubound(strArray) &gt;= 5<br />
then trim(strArray[5])<br />
else &quot;&quot;<br />
how can I do that?
</div>
</div>


I have a formula that works perfect for finding a value in a string field. How can I expand on that 
and actually pull and print out either a value of    "ft" or "in" . Currently the formula pulls out everything like "12 ft" or "24 in" I need to use this formula in some capacity then expand on it.

local stringvar array strArray := split({InvoiceLine.InvoiceLineDesc},",");
if ubound(strArray) >= 5
then trim(strArray[5])
else ""
how can I do that?

Crystal Reports retreiving specific characters from a stringvar array?

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.