title: Replace \x0D\x0A with a space in Unix. Sed
body: <p>I am trying to replace with a space the line feed (\x0A) and carriage return (\x0D) characters automatically.</p>
  
  <p>The characters appear in a table that I have exported with UTF-8 encoding from a database in Sybase, in Windows. I am manipulating the file in Unix. </p>
  
  <p>So far, I was able to delete them manually in text editors, with normal search mode (not escape characters option), but I would like to run it for several tables.</p>
  
  <p>I have used unsuccessfully:</p>
  
  <pre><code>sed -i -e 's/\x0D\x0A/ /g' file_name.csv
  </code></pre>
  
  <p><strong>Edited</strong>:</p>
  
  <pre><code>sed -i -e 's/%\x0D\x0A%/ /g' file_name.csv
  sed -i -e 's/%\CR\LF%/ /g' file_name.csv
  sed -i -e 's/%\r\n%/ /g' file_name.csv
  tr '\15\12'  '  ' &lt; file_name.cvs
  tr '\x0D\x0A'  '  ' &lt; file_name.cvs
  </code></pre>
  
  <p>This is how a row of the table looks like: </p>
  
  <p><strong>30,57786,'B1','Philadelphia Coll Pharm 1879\x0D\x0A','Leaves'</strong></p>