title: How can I implement a pre-processing app for bank statement CSV files?
body: <p>I wish to write some sort of pre-processor for bank statement data provided in the form of a CSV file. Requirements are quite simple, and include:</p>
  
  <ol>
  <li>Only extracting one particular set of rows from the input file.</li>
  <li>Transforming a custom date format to a standard, recognized date format.</li>
  <li>Interpreting the <a href="http://en.wikipedia.org/wiki/Debits_and_credits" rel="nofollow" title="Debit">DR</a>/<a href="http://en.wikipedia.org/wiki/Debits_and_credits" rel="nofollow" title="Credit">CR</a> indicator and appropriately setting the sign on the amount field.</li>
  <li><strike>Parsing a memo type field into separate fields, based on data at the beginning of the memo field.</strike></li>
  </ol>
  
  <p>I could eat this for breakfast in a simple C# command line tool, but I think this application is much more suited to a scripted, non-compiled implementation. I want to avoid VBScript at all costs, just because it's so ugly. I have just installed ActivePerl and would like to get to know Perl much better, but I have no idea where to even start.</p>
  
  <p>I think my most effective question here would then be: Where can I find articles or examples etc. that will help be achieve what I want to, preferably using a scripting platform readily available for Windows 7.</p>
  
  <p><strong>ADDED:</strong>  Based on initial feedback, it looks like I will be using Perl with the <a href="http://search.cpan.org/perldoc/Text%3a%3aCSV_XS" rel="nofollow">Text::CSV_XS</a> and <a href="http://search.cpan.org/perldoc/Time%3a%3aPiece" rel="nofollow">Time::Piece</a> packages. I can easily install these with <strong>ppm</strong>, but how would I deploy my solution to a target Windows 7 client machine? I would much prefer to avoid having to include instructions for the client to <em>type 'ppm xxxx' and wait for the package to install</em> etc.</p>