title: Deleting items in a csv file?
body: <p>I have an .csv with four or five columns of data for webstats.</p>
  
  <p>I analyzed the data with a program how I wanted to, and now I have a text file with a list of the pages I want and I'd like to delete all of the data for every page I don't need, so that only the ones from the text file remain.</p>
  
  <p>i.e. If I have the .csv as follows:</p>
  
  <pre><code>/fruits-and-veggies/apples    16    3    03:43    .72%
  /fruits-and-veggies/pears    8    2    02:34    .65%
  /fruits-and-veggies/broccoli    6    5    04:23    .87%
  /fruits-and-veggies/asparagus    46    6    01:23    .77%
  /fruits-and-veggies/passion-fruit    36    7    05:53    .74%
  </code></pre>
  
  <p>And I have the text file as follows:</p>
  
  <pre><code>/fruits-and-veggies/apples
  /fruits-and-veggies/pears
  /fruits-and-veggies/passion-fruit
  </code></pre>
  
  <p>How do I manipulate the excel file so it only reads:</p>
  
  <pre><code>/fruits-and-veggies/apples    16    3    03:43    .72%
  /fruits-and-veggies/pears    8    2    02:34    .65%
  /fruits-and-veggies/passion-fruit    36    7    05:53    .74%
  </code></pre>
  
  <p>I've heavily researched this topic and have yet to come up with a viable solution. I'm using Windows XP, and batch files are favored if its possible, but I really don't know where start.</p>