<div>
Another thing that might be happening is the case is an issue.<br />
<br />
Replace(Replace({Command.n<wbr />arrative},<wbr />'format','<wbr /> ',,1),'nostock',' ',,1)<br />
<br />
The 1 tells replace to do a non-case sensitive replace<br />
<br />
Your method fails because you have the second test in the else clause so it is only tested for strings that don't have format in them.<br />
<br />
mlmcc
</div>


Another thing that might be happening is the case is an issue.

Replace(Replace({Command.narrative},'format',' ',,1),'nostock',' ',,1)

The 1 tells replace to do a non-case sensitive replace

Your method fails because you have the second test in the else clause so it is only tested for strings that don't have format in them.

mlmcc

<div>
<div class="content wysiwyg-content">
CR2008<br />
<br />
I am using the following formula in a report, to replace certain <br />
<br />
if {Command.narrative} like '*format*' then replace({Command.narrative<wbr />},'format'<wbr />,' ') else<br />
if {Command.narrative} like '*nostock*' then replace({Command.narrative<wbr />},'nostock<wbr />',' ') else <br />
{Command.narrative}<br />
<br />
The problem is that the first line of the formula works but the 2nd line doesn't i.e. it doesn't replace any words with nostock in with ''.<br />
<br />
Any help would be appreciated
</div>
</div>


CR2008

I am using the following formula in a report, to replace certain 

if {Command.narrative} like '*format*' then replace({Command.narrative},'format',' ') else
if {Command.narrative} like '*nostock*' then replace({Command.narrative},'nostock',' ') else 
{Command.narrative}

The problem is that the first line of the formula works but the 2nd line doesn't i.e. it doesn't replace any words with nostock in with ''.

Any help would be appreciated

Problems with REPLACE

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.