title: How to replace CR and LF in Data Factory expressions
body: <p>There doesn't seem to be a clear answer to this, I am using a mapping data flow and a derived column expression.  I have data coming through that has spaces, carriage returns and line feeds, which I want to replace with nothing. For instance:</p>
  <pre><code>Jenny Mc Carthy  -  15 Somewhere Road
  Someplace SomePostcode
  SomeCity
  </code></pre>
  <p>This is columns: FirstName/LastName/Address. I want it to be:</p>
  <pre><code>JennyMcCarthy-15SomewhereRoadSomeplaceSomePostcodeSomeCity
  </code></pre>
  <p>Data Factory expressions should let me do this, I tried this and it didn't seem to work:</p>
  <pre><code>replace(replace(replace(FirstName+LastName+Address,' ',''),'\\r',''),'\\n','')
  </code></pre>
  <p>Anyone know how to do this?</p>