title: How to find and replace a specific word in string?
body: <p>I just want to replace a particular text with blank space in RDLC column.</p>
  
  <p>I want to replace .aspx with <code>""</code> in every string.</p>
  
  <p>I tried writing</p>
  
  <pre><code>=Replace(Fields!AuditsUserActivity.Value, ".aspx", "")
  </code></pre>
  
  <p>it works for this kinda lines</p>
  
  <pre><code>Page Applicants.aspx viewed 
  </code></pre>
  
  <p>but not for these kinda lines:</p>
  
  <pre><code>Data added in Inspectors.aspx
  </code></pre>
  
  <p>i.e. it removed .aspx from those lines in which .aspx appears in in-between but not for those in which .aspx appears at the end of string.</p>
  
  <p>WHY ?</p>
  
  <p>Update: </p>
  
  <p>I used this but not working </p>
  
  <pre><code>=Replace(Fields!AuditsUserActivity.Value, "@"+".aspx", string.Empty)
  </code></pre>