title: Notepad++ regex replace - replace all commas with \, within quotations
body: <p>I am trying to import a csv file into mysql, and I need to convert it into a proper format before importing.</p>
  
  <p>If there's a comma in a column, the csv encloses it within double quotations, here's an example of a row without a comma, and a row with a comma:</p>
  
  <pre><code>1,Superman
  2,"Batman,Flash"
  </code></pre>
  
  <p>What I need to do is to convert all columns which have commas to escape the comma and remove the quotations... such as <code>"Batman,Flash"</code> to <code>Batman\,Flash</code></p>
  
  <p>Here's what I have so far</p>
  
  <pre><code>Find: "(.*),(.*)"
  Replace: \1\\,\2
  </code></pre>
  
  <p>However, there are two cases in which this does not work:</p>
  
  <ul>
  <li>It will only replace one comma if there's more than one comma withing a quoted column. So something like <code>"Batman,Flash,Robin"</code> will be converted to <code>Batman,Flash\,Robin</code></li>
  <li>This doesn't work if the first column has a comma as well. For example, on a row such as <code>"1,2,3","Batman,Robin"</code></li>
  </ul>
  
  <p>How can I change the regexes to accommodate the two cases that don't yet work?</p>