Expression to remove carriage return in SSRS

Question

I am trying to get an expression to work in SSRS.

I have an address block stored in an Oracle database with carriage returns.

The data stored in the database are given as an example:

123 Anywhere Street<CR><LF>
SOMETOWN-ON-SEA<CR><LF>
NARNIA<CR><LF>
AA1 1AA<CR><LF>

I created an expression in a field in SSRS that looks like this:

=Replace(Fields.Address, vbCRLF, " ")

This seems to be correct, but in the end I:

123 Anywhere StreetSOMETOWN-ON-SEANARNIAAA1 1AA

What did he do with the spaces that I told him to add? Why aren't they there?

Note: Well, yes, I could just replace it with PL / SQL, and yes, it will solve my problem, but it is not quite so. I want to know why it does not work in SSRS

Answer 1

10 13. :

=Replace(Replace(Fields!ADDRESS.Value, Chr(13), ""), Chr(10), " ")