title: Parsing a colon-separated values with broken quotes in bash
body: <p>I have a colon-separated file <code>cik.coleft.c</code>, which looks like this:</p>
  
  <pre><code>!J INC:0001438823:
  #1 A LIFESAFER HOLDINGS, INC.:0001509607:
  #1 ARIZONA DISCOUNT PROPERTIES LLC:0001457512:
  #1 PAINTBALL CORP:0001433777:
  $ LLC:0001427189:
  &amp; S MEDIA GROUP LLC:0001447162:
  &amp;TV COMMUNICATIONS INC.:0001479357:
  'MKTG, INC.':0000886475:
  11:11 CAPITAL CORP.:0001463262:
  </code></pre>
  
  <p>It's a two-column <code>csv</code> where separating commas were replaced with colons. Meanwhile, single quotes escape values with commas, instead of values with colons (the separator).</p>
  
  <p>But the first column contains colons, which break parsers. So when I try to convert <code>cik.coleft.c</code> into normal <code>csv</code>...</p>
  
  <pre><code>curl -o cik.coleft.c 'https://www.sec.gov/edgar/NYU/cik.coleft.c'
  
  in2csv --format 'csv' -d ':' -q "'" -e 'latin1' cik.coleft.c &gt; cik.coleft.csv
  </code></pre>
  
  <p>... I get four and more columns.</p>
  
  <p>I tried reading the lines with <code>sed</code>, but haven't succeed.</p>
  
  <p>How can I convert this into a proper two-column table?</p>