title: trying to remove certain characters from inside of double quotes but leave them intact as delimiters
body: <p>remove characters(semicolons) from inside of quoted string but keep them intact for delimiters</p>
  
  <p>How do I get sed etc. to do this.</p>
  
  <p>My input file</p>
  
  <pre><code>"1234";"ABCDE;";"9999"
  "2344;";"PQRST"; "3456;"
  </code></pre>
  
  <p>My outpuft file needs to be cleaned up to look like</p>
  
  <pre><code>"1234";"ABCDE";"9999"
  "2344";"PQRST";"3456"
  </code></pre>
  
  <p>As seen above the semicolons need to be retained as delimiters but need to be removed from the quoted parts. Would anyone be able to let me know? Thanks.</p>
  
  <p>I am actually doing some hive programming and my hive scripts are ready and running successfully (as tested on smaller sample data sets). Now those same scripts are giving me errors since these new big data sets are not clean and hence trying to clean them up (&amp; learning sed etc. along the way).</p>
  
  <p>regards,
  Rahul</p>