title: CSV to Dictionary, matching up column titles and row values?
body: <p>I feel quite embarrassed to ask this, but I simply cannot get my desired results.</p>
  
  <p>I have a CSV file which looks like this:</p>
  
  <pre><code>Col_Title_1|Col_Title_2|Col_Title_3|Col_Title_4|Col_Title_5
    Value_1  |  Value_2  |  Value_3  |  Value_4  |  Value_5
  </code></pre>
  
  <p>I want to read this data and manipulate it such as (pseudo code):</p>
  
  <pre><code>var test = array.Column("Col_Title_3").Value;
  </code></pre>
  
  <p>I just can't seem to pair the column and value up accordingly.</p>
  
  <p>Is a dictionary or KeyValuePair best to use?</p>
  
  <p>Here is 1 good test I did but of course does not work 100%:</p>
  
  <pre><code>Dictionary&lt;string, string&gt; dict = File.ReadLines(e.FullPath).Select(line =&gt;
  line.Split('|')).ToDictionary(line =&gt; line[0], line =&gt; line[1]);
  </code></pre>
  
  <p>I know I can do a hacky/hard code way like so:</p>
  
  <pre><code>string lineValues = File.ReadLines(e.FullPath).ElementAt(1);
  string row3 = lineValues.Split('|')[2];
  string row5 = lineValues.Split('|')[4];
  </code></pre>
  
  <p>But for obvious reasons I do not want to do it like this.</p>
  
  <p>Any help will be greatly appreciated! Thanks all!</p>