title: insert part of file name into (first) column of csv
body: <p>I have hundreds of csv files with filenames in the following format: yyyymmdd_something.csv, e.g. 20131213_something.csv ... i.e., an underscore separates the date from the rest of the filename.</p>
  
  <p>Each of has the following fields:
  Make, Model, metric 1, metric 2, etc.</p>
  
  <p>I would like to:</p>
  
  <p>1) Insert the date from the file name into (preferably first) column, like so:</p>
  
  <p>Date, Make, Model, metric 1, metric 2, etc.</p>
  
  <p>But really it can be any column because once in Excel, it is a simple matter to re-arrange it. The date should be added as mm/dd/yyyy as it is what Excel understands.</p>
  
  <p>2) After inserting the date, I would like to merge all the csv into 1 big csv file.</p>
  
  <p>I'm using a Win7 machine so a dos batch file would probably be the simplest way to run it for me but if I had to, I can install perl or something to do this. Any help would be deeply appreciated. There was a thread that talks about inserting the whole file name but I really need only the date part added.</p>