title: Use REGEX to find line breaks within a wrapped content
body: <p>The direct question: How can I use REGEX lookarounds to find instances of \r\n that occur between a set of characters (stand in open and closing tags), <code>"[</code> and <code>]"</code> with arbitrary characters and line breaks inside as well?</p>
  
  <p>The situation:</p>
  
  <p>I have a large database exported to tab or comma delineated text files that I'm trying to import into excel. The problem is that some of the cells come from text areas that contain line breaks, and are qualified by double quotes. Importing into excel these line breaks are treated as new rows. I cannot adjust how the file is exported. I data needs to be preserved, but the exact format doesn't, so I was planning on using some placeholder for the returns <br> or ~</p>
  
  <p>Here's a generic illustration of the format of my data:</p>
  
  <pre><code>column1rowA    column2rowA    column3rowA    column4rowA
  column1rowB    column2rowB   "column3rowB
  3Bcont
  3Bcont
  3Bcont
  
  "    column4rowB
  column1rowC    column2rowC                   column4rowC
  column1rowD    column2rowD   "column3rowD
  3Dcont"    column4rowD
  </code></pre>
  
  <p>My thought has been to try to select and replace line breaks within the quotes using REGEX search and replace in Notepad++. To try and make is simpler I have tried adding a character to the double quotes to help indicate whether it is an opening or closing quote:</p>
  
  <pre><code>"[column3rowB
  3Bcont
  3Bcont
  3Bcont
  
  ]"
  </code></pre>
  
  <p>I am new to REGEX. The progress I've made (which isn't much) is:</p>
  
  <p><code>(?&lt;="[)</code> missing some sort of wildcard <code>\r\n(?=.*]")</code></p>
  
  <p>Every iteration I've tried has <em>also</em> included every line break between the first <code>"[</code> and last <code>]"</code></p>
  
  <p>I would also appreciate any other approaches that solve the underlying problem</p>