title: Vertica new-line CR LF replace
body: <p>I have a column in vertica which I wish to export to .csv.
  The problem is that this column has CRLF in the middle, meaning that the export reads each line as two lines. Example of input(the EOF delimiter was copy pasted from Vertica):</p>
  
  <pre><code>First part
  Second part
  </code></pre>
  
  <p>I tried the REPLACE option but it does not replace the sequence. </p>
  
  <pre><code>select TABLE, REPLACE(column_name, '\r\n', 'FUFU') from DB;
  </code></pre>
  
  <p>The command does replace random letters. </p>
  
  <p>Hence I start to question if there is a CRLF (Notepad++ found it) or if there is some other character hidden there which I fail to replace...</p>
  
  <p>Any help on what are other possible causes for the new line (I tried \n, \c, \r and any possible combinations...) or how to see it other than in Notepad (directly in Vertica?) will be greatly appreciated... </p>
  
  <p>Alternatively, I found no way to explicitly define in Vertica the EOF characters on export - does something like this exist?
  Thanks</p>