title: Query to run strings against a list and extracting data
body: <p>I work in the IT department for a company, and one of the task that falls under my task list is regularly updating the phone dial plan(every 3 months or so) to ensure all local area codes and exchanges are up to date.</p>
  
  <p>I usually go to the following website which gets updated every month to get a list of area codes and exchanges and look manually through another list I have which has all the regions I need to check for. The list is formatted for CSV, so I could paste it in excel or a DB.</p>
  
  <p>My question is, is there a query I can run that will take all the regions from list 2, compare it against list 1, and get the first and second column of list 1? I believe this can be achieved by SQL or Excel or perhaps another way using Powershell or Linux scripting.
  Since I will be doing this regularly, I would just want to paste the new list every month, run it against my list 2, and get all the new exchanges added.</p>
  
  <pre><code> Sample of List 1:
  
   http://cnac.ca/data/COCodeStatus_NPA613.txt
   613,200,8303,TELUS Mobility,In Service,Perth,
   613,201,920D,Westport Telephone Company Limited,In Service,Perth,
   613,202,8821,Rogers Communications Partnership (Wireless),In Service,Bancroft,
   613,203,6574,Bell Mobility,In Service,Ottawa-Hull,
   613,204,6574,Bell Mobility,In Service,Ottawa-Hull,
   613,205,2782,TELUS Integrated Communications,In Service,Smiths Falls,
   613,206,8303,TELUS Mobility,In Service,Smiths Falls,
   613,207,8303,TELUS Mobility,In Service,Smiths Falls,
   613,208,8377,Rogers Communications Partnership (Cable),In Service,Trenton,
   613,209,154E,Iristel Inc.,In Service,Cornwall,
   613,210,8377,Rogers Communications Partnership (Cable),In Service,Belleville,
   613,211,,,For Special Use,,Public Information and Referral Services
   613,212,2782,TELUS Integrated Communications,In Service,Ottawa-Hull,
   613,213,6574,Bell Mobility,In Service,Brockville,
   613,214,6574,Bell Mobility,In Service,Kingston,
   613,215,2782,TELUS Integrated Communications,In Service,Kemptville,
   613,216,8377,Rogers Communications Partnership (Cable),In Service,Ottawa-Hull,
   613,217,6574,Bell Mobility,In Service,Kingston,
   613,218,8821,Rogers Communications Partnership (Wireless),In Service,Ottawa-Hull,
   613,219,8821,Rogers Communications Partnership (Wireless),In Service,Ottawa-Hull,
   613,220,8821,Rogers Communications Partnership (Wireless),In Service,Ottawa-Hull,
   613,221,8051,Bell Canada,In Service,Ottawa-Hull,
   613,222,6574,Bell Mobility,In Service,Ottawa-Hull,
   613,223,8819,TELUS Mobility,In Service,Ottawa-Hull,
   613,224,8051,Bell Canada,In Service,Ottawa-Hull,
   613,225,8051,Bell Canada,In Service,Ottawa-Hull,
   613,226,8051,Bell Canada,In Service,Ottawa-Hull,
   613,227,8819,TELUS Mobility,In Service,Ottawa-Hull,
   613,228,8051,Bell Canada,In Service,Ottawa-Hull,
   613,229,8819,TELUS Mobility,In Service,Ottawa-Hull,
   613,230,8051,Bell Canada,In Service,Ottawa-Hull,
   613,231,8051,Bell Canada,In Service,Ottawa-Hull,
   613,232,8051,Bell Canada,In Service,Ottawa-Hull,
   613,233,8051,Bell Canada,In Service,Ottawa-Hull,
   613,234,8051,Bell Canada,In Service,Ottawa-Hull,
   613,235,8051,Bell Canada,In Service,Ottawa-Hull,
  
   Sample of List 2:
   Carleton Place, Ont
   Carp, Ont
   Casselman, Ont
   Chelsea, Que
   chesterville, Ont
  </code></pre>
  
  <p>EDIT: I would also like the script to verify column "Status" and make sure all numbers returned have the status "In service" but doesn't display "In Service" in the output. I would like the output to display just the area code followed by the exchange(EX. 613230)</p>