<div>
You are right about the 10th position in the above post. &nbsp;I left out a few unneeded characters from data I was working with for simplification. &nbsp;<br />
<br />
Thanks for the tip. That definitely did what was needed. &nbsp;<br />
<br />
I think I found another way to do the same thing from browsing around the site. &nbsp;<br />
<br />
tonumber(Mid(Split({table.<wbr />field},&quot;|&quot;<wbr />)[1],12))<br />
<br />
Thanks again for the quick response!
</div>


You are right about the 10th position in the above post.  I left out a few unneeded characters from data I was working with for simplification.  

Thanks for the tip. That definitely did what was needed.  

I think I found another way to do the same thing from browsing around the site.  

tonumber(Mid(Split({table.field},"|")[1],12))

Thanks again for the quick response!

<div>
Exactly what I was looking for.
</div>


<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I need some help with a Crystal formula on a string.<br />
<br />
I have a string of data I want to manipulate. In Crystal that looks like this:<br />
&quot;ACCT_NBR=123456|iD_NUM=12<wbr />3456&quot;<br />
<br />
i want to just pull out the acct_nbr field. &nbsp;It will always start after the equals sign at the 12th character. &nbsp;The field length could be 4 to 6 characters then ends with the pipe.<br />
<br />
What is the correct function to just pull out the acct_nbr? &nbsp;I was messing around with a few but could not get it quite right.
</div>
</div>


Hello all,

I need some help with a Crystal formula on a string.

I have a string of data I want to manipulate. In Crystal that looks like this:
"ACCT_NBR=123456|iD_NUM=123456"

i want to just pull out the acct_nbr field.  It will always start after the equals sign at the 12th character.  The field length could be 4 to 6 characters then ends with the pipe.

What is the correct function to just pull out the acct_nbr?  I was messing around with a few but could not get it quite right.

Manipulating string data 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.