title: How to compare 2 .csv files and create a new .csv containing parts from both csv files?
body: <p>I am trying to compare two specific parts of CSV files.</p>
  
  <pre><code>JobStart.csv
  test1;test2;test3;test4;Val2Compare2;test5;test6;test7....
  
  Datafile.csv
  line 1   Val2Compare1; data1;data2;data3;data4;data5;data6
  line 2   Val2Compare2; data1;data2;data3;data4;data5;data6
  line 3   Val2Compare3; data1;data2;data3;data4;data5;data6
  </code></pre>
  
  <hr>
  
  <p>What I want to do is: </p>
  
  <p>Compare values: JobStart.csv Val2Compare2 to </p>
  
  <pre><code>     Datafile.csv          Val2Compare1
                             Val2Compare2
                             Val2Compare3
                             ...
  </code></pre>
  
  <p>When I got which line is true (in this case line2). Then I want to combine JobStat.csv and Datafile.csv like so:</p>
  
  <pre><code>NEW JOBSTART.CSV
  
  
  test1;test2;test3;test4;Val2Compare2;test5;test6;test7; data1;data2;data3;data4;data5
  </code></pre>
  
  <p>I tried to look at:</p>
  
  <p><a href="https://stackoverflow.com/questions/5154370/compare-two-csv-file-using-in-c-sharp">Compare two csv file using in C#</a></p>
  
  <p><a href="https://stackoverflow.com/questions/11880894/comparing-specific-columns-of-two-csv-files">Comparing specific columns of two csv files</a></p>
  
  <p><a href="https://stackoverflow.com/questions/17526730/compare-2-csv-files-and-replace-updated-values">Compare 2 csv files and replace updated values</a></p>
  
  <p><a href="http://social.msdn.microsoft.com/Forums/vstudio/en-US/3f334045-2ac7-44b9-afaa-bd8d83c8ef27/read-csv-file-and-get-specific-column-from-each-line?forum=csharpgeneral" rel="nofollow noreferrer">http://social.msdn.microsoft.com/Forums/vstudio/en-US/3f334045-2ac7-44b9-afaa-bd8d83c8ef27/read-csv-file-and-get-specific-column-from-each-line?forum=csharpgeneral</a></p>
  
  <p>But couldn't get much help.</p>