title: Csv file containing new line (multi line)
body: <p>We are working on a project where are planning to generate multi line csv files and load to informatica via power exchange. </p>
  
  <p>Our csv file will look like as below. </p>
  
  <pre><code>Field1, Field2
  "Row 1 Cell 1 line 1
   Row 1 Cell 1 line 2", "Row 1 Cell 2 Line 1
   Row 1 Cell 2 line 2"
   "Row 2 Cell 1 line 1
    Row 2 Cell 1 line 2", "Row 2 Cell 2 Line 1
    Row 2 Cell 2 Line 2"
  </code></pre>
  
  <p>Just wanted to check will power exchange understand this type of csv file? </p>
  
  <p><strong>Update:</strong> We tried loading a sample file to power exchange and it converted the new lines to space :-( Is there a way to retain then as new line and load to the data center as new line?</p>