title: C# split text when delimiter may be in values
body: <p>I have a text file which is and extract from database. Each line is one record and I'm trying to parse it.</p>
  
  <p>Here is the troublesome part after some anonymisation:</p>
  
  <pre><code>"CODE0001"  "Name1  "   14.46   0.05
  "CODE0002"  "Name2" 17.37   0.05    
  "CODE0003"  "Name3" 22.66   0.05
  </code></pre>
  
  <p>It may have strings or numbers, separated by tabulators. Strings are in brackets. Unfortunately tabulators may happen also in names like "Name1 "
  which I learnt by getting some parse errors.</p>
  
  <p>My first code was:</p>
  
  <pre><code>string[] articles = File.ReadAllLines(myFile);
  char[] separators = { '\t' };
  
  for (int i = 0; i &lt; articles.Length; i++)             
  {
      string[] article = articles[i].Split(separators);
      string code = article[0];
      string name = article[1];
      string val1 = article[2];
      string val2 = article[3];
      //do something with these values
   }
  </code></pre>
  
  <p>But if there is a tabulator in some name it goes wrong.</p>
  
  <p>How could I split and parse these lines ignoring tabs in names (surrounded by brackets) and detecting only true delimiters?</p>