title: Regular expression to manipulate text file - Windows
body: <p>I am having issues manipulating a text file to get my desired results. </p>
  
  <p>For example, I have the following lines within a text file called <code>sprocs.txt</code> which was created from an svn diff, similar to this:</p>
  
  <pre><code>     M      https://localhost/svn/Repo/branches/projectA/sprocs/admin/foo.sql
       M      https://localhost/svn/Repo/branches/projectA/sprocs/foo2.sql
       M      https://localhost/svn/Repo/branches/projectA/sprocs/admin
       M      https://localhost/svn/Repo/branches/projectA/sprocs
  </code></pre>
  
  <p>I am trying to edit this file so that it keeps everything starting with <code>/sprocs</code>, but deletes each line that does not end in <code>.sql</code>. For example, the file above would return the following:</p>
  
  <pre><code>    /sprocs/admin/foo.sql 
      /sprocs/foo2.sql
  </code></pre>
  
  <p>BTW: I plan to have these commands be handled by nant. Any ideas anyone? Thanks in advance.</p>