title: Redshift: how to remove all newline characters in a field
body: <p>I am wondering how I can remove all newline characters in Redshift from a field. I tried something like this:</p>
  
  <pre><code>replace(replace(body, '\n', ' '), '\r', ' ')
  </code></pre>
  
  <p>and</p>
  
  <pre><code>regexp_replace(body, '[\n\r]+', ' ')
  </code></pre>
  
  <p>But it didn't work. Please share if you know how to do this.</p>