title: read csv file with new line character as data java
body: <p>I need your help here . Trying to figure out if there is a better solution than manipulation of data in the text file.</p>
  
  <p>So i have a csv file where some of the data has new line characters in it. This file is generated from the salesforce portal </p>
  
  <p>The issue occurs when i try to read this file line by line to insert in a sql table in the database.</p>
  
  <pre><code>    BufferedReader bReader = new BufferedReader(new InputStreamReader(con.getInputStream()));
      line = bReader.readLine() 
  </code></pre>
  
  <p>interprets the new line in the data as end of line . as a result this line is interepreted as 2 lines.
  Any idea how can handle such data while reading the file.</p>
  
  <p>Any insights would be highly appreciated.</p>
  
  <p>Thanks.</p>