<div>
It appears the formula is used not used in the group or details sections. &nbsp;The formula field must be in the group or details section. &nbsp;If the field is not group or details sections the formula is not run for each record.
</div>


It appears the formula is used not used in the group or details sections.  The formula field must be in the group or details section.  If the field is not group or details sections the formula is not run for each record.

<div>
If you want to complete the replacement before crystal loads the data, you can use a t-sql statement to the database. &nbsp;Here are instructions <a href="http://hexcentral.com/articles/crystal-sql.htm" rel="ugc">http://hexcentral.com/articles/crystal-sql.htm</a>.
</div>


If you want to complete the replacement before crystal loads the data, you can use a t-sql statement to the database.  Here are instructions http://hexcentral.com/articles/crystal-sql.htm [http://hexcentral.com/articles/crystal-sql.htm].

<div>
nest the replace function?<br />
<br />
replace(replace(database_f<wbr />ield, 'Will for ',''),'Will For ','')
</div>


nest the replace function?

replace(replace(database_field, 'Will for ',''),'Will For ','')

<div>
@mlmcc - excellent! <br />
Where does one find formal online doco for crystal functions these days?
</div>


@mlmcc - excellent!
Where does one find formal online doco for crystal functions these days?

<div>
I don't know of an online help. &nbsp;I use the help from Crystal installed on my machine.<br />
<br />
mlmcc
</div>


I don't know of an online help.  I use the help from Crystal installed on my machine.

mlmcc

<div>
<div class="content wysiwyg-content">
I have data in one of the fields I am reporting against as below<br />
<br />
Will for John Smith<br />
Will For John Blogg<br />
<br />
I want to remove the Will for to just have the name left i.e. John Smith, John Blogg<br />
<br />
I am using the formula below<br />
<br />
replace(database_field, 'Will for ','')<br />
<br />
When I use this I am left with<br />
<br />
John Smith and Will For John Blogg, i.e. it still leaves the one with the capital F for For.<br />
<br />
How can make this work so I am left with John Smith, John Blogg from the example data
</div>
</div>


I have data in one of the fields I am reporting against as below

Will for John Smith
Will For John Blogg

I want to remove the Will for to just have the name left i.e. John Smith, John Blogg

I am using the formula below

replace(database_field, 'Will for ','')

When I use this I am left with

John Smith and Will For John Blogg, i.e. it still leaves the one with the capital F for For.

How can make this work so I am left with John Smith, John Blogg from the example data

Replace Problem

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.