title: Windows batch code to merge file and edit
body: <p>I have a lot of csv file into a folder.
  The files are named like <code>OPERATORS_*.csv</code> where <code>*</code> is a variable.</p>
  
  <p>I want, using a batch file, to merge all files into one, delete the first row of each file and add at the end of each row the <code>*</code>.</p>
  
  <p>I have tried this code:</p>
  
  <pre><code>copy /b OPERATORS_*.csv OPERATORS_FULL.csv
  </code></pre>
  
  <p>This way is fine, but the first row of each file is printed and i lost the attribute in the filename. </p>
  
  <p>Example:</p>
  
  <p>OPERATORS_ACTIVITY1.csv</p>
  
  <pre><code>OPT;SALES;REDEMPTION
  OPT1;12;75
  </code></pre>
  
  <p>OPERATORS_ACTIVITY2.csv</p>
  
  <pre><code>OPT;SALES;REDEMPTION
  OPT2;22;64
  </code></pre>
  
  <p>and i want this:</p>
  
  <p>OPERATORS_FULL.csv</p>
  
  <pre><code>OPT1;12;75;ACTIVITY1
  OPT2;22;64;ACTIVITY2
  </code></pre>
  
  <p>Any suggestions?</p>