title: CSV file: newline in file
body: <p>I have data in a database that needs to be exported to CSV. Some of the fields include addresses and such, which include newlines which <strong>MUST</strong> be preserved. The data is being exported like this (this is sample data of course):</p>
  
  <pre><code>"Bob Smith",38,"Fire Chief","1234 Obscure St.
  Random Town, NA, 12345"
  </code></pre>
  
  <p>Which doesn't show up correctly in Excel, or import correctly with <a href="http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.aspx" rel="nofollow">TextFieldParser</a> class. Is it possible to export newlines in CSV files? How?</p>