title: How to add constant value to CSV using batch file?
body: <p>I have a bunch of CSV files that I want to add a constant value to before I merge them so that I know which CSV file each row came from.  I am currently using a simple batch file to merge the CSV files, but I need an identifier to sort the merged file on.</p>
  
  <pre><code>copy *.csv importfile.csv 
  </code></pre>
  
  <p>so i need to add a constant column of 1's to each row in CSV-A, a constant column of 2's to CSV-B, 3's to CSV-C etc..... before merging the files.</p>
  
  <p>I am sure this is possible, but I have no idea where to start? Can anyone help?</p>
  
  <p>Another option would be..... </p>
  
  <pre><code>If any row in column K in CSV-A.csv = "Certain Value" 
  change to "1" 
  ELSE do nothing 
  </code></pre>