title: looping through a csv
body: <p>just wondering if i could do this in powershell, or even a c#/vb.net command line program.</p>
  
  <p>I have data that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/WmD3A.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WmD3A.jpg" alt="alt text"></a><br>
  <sub>(source: <a href="http://www.kalleload.net/uploads/qubtqmuikowt.jpg" rel="nofollow noreferrer">kalleload.net</a>)</sub>  </p>
  
  <p>I  have a Teams Table. It looks like this:</p>
  
  <p>| id | teamname | teamcity | </p>
  
  <p>so for example, C2 has the value "Atlanta Braves". I need to split this up into "Atlanta" and "Braves". Data is consistent. for example "New York Mets" is actually "NewYork Mets".</p>
  
  <p>So i need to go through column C and D and insert all the teams (no duplicates into the db).</p>