title: Sed - remove all semicolons between a pair of double-quotes
body: <p>I have a dirty csv-file containing rows with quoted semicolons. I am trying to clear these semicolons with commands like:</p>
  <pre><code>sed -rin 's/(^.*\;.*\;\&quot;.*)(\;)(.*\&quot;\;.*$)/\1\3/' file
  </code></pre>
  <p>But somehow this doesn't remove all of the semicolons. Some of the problematic rows look like this:</p>
  <pre><code>;0;&quot;One ▒;)&quot;;123; ... ; nth-1column;
  ;0;&quot;Two ▒;)&quot;;456; ... ; nthcolumn;
  </code></pre>
  <p>When they should be cleaned to:</p>
  <pre><code>;0;&quot;One ▒)&quot;;123; ... ; nth-1column;
  ;0;&quot;Two ▒)&quot;;456; ... ; nthcolumn;
  </code></pre>
  <p>There might be some encoding issues, but this should be ignored by the regex. I am only interested in removing the semicolons, the encoding is handled afterwards.</p>
  <p>Any ideas on how to aggressively clean all semicolons contained within double-quotes?</p>