title: Removing characters from a CSV file
body: <p>I have a CSV file, that contains data exported from a mySQL table. In one of the fields, there is a newline character, which "splits" the field into 2 lines. I'm trying to remove this newline character, but can't seem to do it. </p>
  
  <p>Also, the same field may contain double quotes and commas, which gives me trouble when I enclose the fields with <code>"</code> terminate them with <code>,</code> when I exported the table. So I used <code>|</code> to terminate the fields instead, and don't enclose the fields with anything.</p>
  
  <p>When I <code>cat</code> the file on a linux machine, the field looks like this</p>
  
  <pre><code>13"\
  58,20,"3
  </code></pre>
  
  <p>What the field is supposed to look like is </p>
  
  <pre><code>13"58,20,"3
  </code></pre>
  
  <p>When I used the vi "hex editor" (<code>:%!xxd</code>) to check the hex values of the line, I get</p>
  
  <pre><code>31 33 22 5c 0a 35 38 2c 32 30 2c 22 33
  </code></pre>
  
  <p>I tried using sed</p>
  
  <pre><code>sed -e 's/\\\n//'
  </code></pre>
  
  <p>and </p>
  
  <pre><code>sed -e 's/\x5c\x0a//'
  </code></pre>
  
  <p>to remove the newline, but they didn't work. How can I format the field to what it's supposed to look like? </p>