title: Extracting Data From DataTable
body: <p>I have a DataTable that has 2 columns as a semi-colon separated list.  I need a way to parse out the data from those columns and "match" them together.  For example, let's take the information for James Jo - I want it to look like this when extracted:</p>
  
  <pre><code>SH11 - Shirt
  HA22 - Hat
  SO33 - Socks
  </code></pre>
  
  <p>And this is my DataTable set-up, it's all string values.</p>
  
  <pre><code>DataTable table = new DataTable();
  table.Columns.Add("Name", typeof(string));
  table.Columns.Add("ItemsSold", typeof(string));
  table.Columns.Add("ItemIDs, typeof(string));
  
  table.Rows.Add("James Jo", "Shirt; Hat; Socks;", "SH11; HA22; SO33");
  table.Rows.Add("Jack Bo", "Pants; Scarf;", "PA44; SC55");
  </code></pre>