title: CR to LF/CR when inserting in MS Access
body: <p>I have a java program which scrapes data from a PDF Form (via PDFBox) and then into a MS Access Database (via Ucanaccess).</p>
  
  <p>A large text string is inserted into a MS Access Long Text field, but I am losing all the line breaks.</p>
  
  <p>Coming from the PDF only seems to be \r (CR) and copying data from the database shows CR+LF.</p>
  
  <p>I assume this is the whole linux/windows thing and basically I should do a replace line like </p>
  
  <pre><code>pdf.get(c).replaceAll("\r", "\r\n");
  </code></pre>
  
  <p>Where pdf is a hashmap and c at somepoint will pull the string containing the memo field.</p>
  
  <p>Cheers</p>
  
  <p>Al</p>