title: Ignore newlines in CSV value
body: <p>So I have a CSV that contains a filename and a file's contents. The file is full of newlines and all sorts of other characters. I need to have each row contain the filename in one column and the file contents in the next column, and then I need a new row, until the end of the file.</p>
  
  <p>The data looks like this:</p>
  
  <pre><code>"filename.txt","hey there
  buddy
  how are you
  doing"
  "filename2.txt","and so on..."
  </code></pre>
  
  <p>According to <a href="http://creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs" rel="nofollow noreferrer">http://creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs</a>, my CSV importer should read those line-breaky values as single values, not new rows. However, I have tried OO Calc, KSpread, Gnumeric, and even Microsoft Excel 2007 and none of them read it that way; they all consider each newline a new row.</p>
  
  <p>Anyone know how to fix this? I've looked through other related questions but none of them seem to say.</p>
  
  <p>If this doesn't work, I'll have to write the file directly with a Python Excel-writing module or something. Anyone know what to do here?</p>