Expression to remove carriage return in SSRS
<p>I am struggling to get an expression to work in SSRS.</p>

<p>I have an address block stored in an Oracle database with carriage return characters.</p>

<p>An example is the data stored in the database is:</p>

<pre><code>123 Anywhere Street&lt;CR&gt;&lt;LF&gt;
SOMETOWN-ON-SEA&lt;CR&gt;&lt;LF&gt;
NARNIA&lt;CR&gt;&lt;LF&gt;
AA1 1AA&lt;CR&gt;&lt;LF&gt;
</code></pre>

<p>I have created an expression on the field in SSRS that looks like this:</p>

<pre><code>=Replace(Fields.Address, vbCRLF, " ")
</code></pre>

<p>Seems like the right thing to do, but what I end up with is:</p>

<pre><code>123 Anywhere StreetSOMETOWN-ON-SEANARNIAAA1 1AA
</code></pre>

<p>What did it do with the spaces I told it to add? Why are they not there?</p>

<p>Note: OK so yeah, I could just do this replace thing in PL/SQL and yeah that will solve my problem, but it's not really the point. I want to know why it isn't working in SSRS</p>