<div>
Try this<br />
<br />
Local NumberVar SDE_Loc;<br />
SDE_Loc := InStr({L_HPCR.OBJECT},&quot;SDE<wbr />&quot;);<br />
Mid({L_HPCR.OBJECT},SDE_Lo<wbr />c)<br />
<br />
mlmcc
</div>


Try this

Local NumberVar SDE_Loc;
SDE_Loc := InStr({L_HPCR.OBJECT},"SDE");
Mid({L_HPCR.OBJECT},SDE_Loc)

mlmcc

<div>
At first it worked, but then I got an error saying&quot; Start Position is less than 1 or not an integer&quot;.<br />
<br />
Ideas?
</div>


At first it worked, but then I got an error saying" Start Position is less than 1 or not an integer".

Ideas?

<div>
Apparently you have strings without the SDE or NULL<br />
<br />
Local NumberVar SDE_Loc;<br />
If IsNull({L_HPCR.OBJECT}) then<br />
&nbsp; &nbsp;&quot;No String&quot;<br />
Else<br />
(<br />
&nbsp; &nbsp; SDE_Loc := InStr({L_HPCR.OBJECT},&quot;SDE<wbr />&quot;);<br />
&nbsp; &nbsp; If SDE_Loc &gt;&nbsp;0 then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Mid({L_HPCR.OBJECT},SDE_Lo<wbr />c)<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;No SDE&quot;<br />
);<br />
<br />
mlmcc<br />
<br />
mlmcc 
</div>


Apparently you have strings without the SDE or NULL

Local NumberVar SDE_Loc;
If IsNull({L_HPCR.OBJECT}) then
   "No String"
Else
(
    SDE_Loc := InStr({L_HPCR.OBJECT},"SDE");
    If SDE_Loc > 0 then
        Mid({L_HPCR.OBJECT},SDE_Loc)
    Else
        "No SDE"
);

mlmcc

mlmcc

<div>
Thats perfect. One last question, what happens if SDE is in lowercase? <br />
How would I capture all versions of the word sde?
</div>


Thats perfect. One last question, what happens if SDE is in lowercase?
How would I capture all versions of the word sde?

<div>
<div class="content wysiwyg-content">
I have comment field in my report that is delimited by commas and spaces;<br />
ex:<br />
Type=D, create user= test user1, modified user = test1, Apply to inventory<br />
Captial#123456<br />
SDE#78910<br />
<br />
I'm trying to search the string and ONLY pull out the information that starts with SDE.<br />
<br />
I&quot;ve tried using the formula: split({L_HPCR.OBJECT},&quot;,&quot;)<wbr />[4], but if the SDE# isn't right after the third comma, it won't display.<br />
<br />
Anyone have any suggestions.<br />
<br />
Thank you
</div>
</div>


I have comment field in my report that is delimited by commas and spaces;
ex:
Type=D, create user= test user1, modified user = test1, Apply to inventory
Captial#123456
SDE#78910

I'm trying to search the string and ONLY pull out the information that starts with SDE.

I"ve tried using the formula: split({L_HPCR.OBJECT},",")[4], but if the SDE# isn't right after the third comma, it won't display.

Anyone have any suggestions.

Thank you

String Search 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.