<div>
Got &nbsp;the following to work<br />
<br />
Replace(dbo.AcctName, MID(dbo.AcctName, InStr(dbo.Acctname, &quot;(&quot;)),&quot;&quot;)<br />
<br />
rhinok's solution looks a lot cleaner though.
</div>


Got  the following to work

Replace(dbo.AcctName, MID(dbo.AcctName, InStr(dbo.Acctname, "(")),"")

rhinok's solution looks a lot cleaner though.

<div>
You colud also use<br />
<br />
Local NumberVar leftparen := Instr(dbo.Acctname,&quot;(&quot;) - 2;<br />
<br />
Left({dbo.Acctname},leftpa<wbr />ren )<br />
<br />
mlmcc
</div>


You colud also use

Local NumberVar leftparen := Instr(dbo.Acctname,"(") - 2;

Left({dbo.Acctname},leftparen )

mlmcc

<div>
<div class="content wysiwyg-content">
Need to turn variable account name into shortened string.<br />
<br />
Example:<br />
<br />
Salaries (Global, NF)<br />
Salaries (CP, NF)<br />
Vehicle Repair (Maint, NF)<br />
<br />
needs to turn into:<br />
<br />
Salaries<br />
Salaries<br />
Vehicle Repair<br />
<br />
Replace( dbo.Acctname, &quot;(*&quot;, &quot;&quot;) and Replace( dbo.Acctname, &quot;*(*&quot;, &quot;&quot;)<br />
are not working. &nbsp;Are wildcards recognized in Crystal Replace? &nbsp;I'm pretty sure I've used wildcard replace in both SQL and access.
</div>
</div>


Need to turn variable account name into shortened string.

Example:

Salaries (Global, NF)
Salaries (CP, NF)
Vehicle Repair (Maint, NF)

needs to turn into:

Salaries
Salaries
Vehicle Repair

Replace( dbo.Acctname, "(*", "") and Replace( dbo.Acctname, "*(*", "")
are not working.  Are wildcards recognized in Crystal Replace?  I'm pretty sure I've used wildcard replace in both SQL and access.

Crystal Reports Replace Portion of String Starting with

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.