title: C# string parse
body: <p>I have string like this</p>
  
  <pre><code>string temp = "'ADDR_LINE_2','MODEL','TABLE',5,'S','Y','C40','MUL,NBLD,NITA,NUND','','Address line 2'"
  </code></pre>
  
  <p>Each pair of single quote is a field delimited by a comma. I want to empty the 8th field in the string. I cannot simply do <code>replace("MUL,NBLD,NITA,NUND","")</code> because that field could contain anything. also please note the the 4th field is a number and therefore has no single quote around <code>5</code>.</p>
  
  <p>How can I achieve this?</p>