title: talend : newline character in middle of csv column
body: <blockquote>
    <p>I am fetching data using tSoap component in which i am getting result in XML format as comma separated values. In which columns are separated by comma and rows are separated by '\n'.</p>
    
    <p>After that i am using tExtractXMLField component for extracting data from the response.</p>
    
    <p>But in data i have '\n' within the strings which is treating it as a new row. I tried using tReplace component to remove \n within the quotes using regex but data is too large, result causing StackOverflowError. </p>
    
    <p>Also I tried using tNomalize component to separate the rows using CSV option, but the problem still persist.</p>
    
    <p>Can you please help me on this. Thanks in advance.</p>
    
    <p>Response which i am getting from the soap request is:</p>
  </blockquote>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>  &lt;env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"&gt;
  &lt;env:Header/&gt;
  &lt;env:Body&gt;
  &lt;ns2:getReportResultCsvResponse xmlns:ns2="http://service.admin.ws.five9.com/"&gt;
  &lt;return&gt;TIMESTAMP,CALL ID,NOTES
  "Mon, 17 Apr 2017 10:05:38",4223519,
  "Mon, 17 Apr 2017 10:05:40",4223520,
  "Mon, 17 Apr 2017 10:05:41",4223521,"Alexandria..
  Monday -- 55 partial
  Bal -- 224 May 1
  Visa"
  "Mon, 17 Apr 2017 10:05:42",4223522,
  "Mon, 17 Apr 2017 10:05:43",4223523,
  "Mon, 17 Apr 2017 10:11:04",4223524,
  "Mon, 17 Apr 2017 10:05:43",4223524,
  "Mon, 17 Apr 2017 10:05:45",4223525,&lt;/return&gt;
  &lt;/ns2:getReportResultCsvResponse&gt;
  &lt;/env:Body&gt;
  &lt;/env:Envelope&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <blockquote>
    <p>Here as we can see "notes" column having data which have '\n' in it in
    between the quotes, and it is causing issue for extracting data. Can
    you please tell me how can i resolve this issue.</p>
  </blockquote>