title: batch file to remove a column in csv
body: <p>I wrote this code so I can remove a column from a csv file.</p>
  
  <pre><code>@echo off
  setlocal enableextensions enabledelayedexpansion
  type nul &gt; tmp.txt
  SET /A COUNT=0
  for /F "tokens=*" %%A in (d.csv) do (
      set LINE="%%A"
      set /A COUNT+=1
      for /F "tokens=1,2,3,4,5,6,7,8,* delims=," %%a in (!LINE!) do (
          set row[0]=%%a
          set row[1]=%%b
          set row[2]=%%c
          set row[3]=%%d
          set row[4]=%%e
          set row[5]=%%f
          set row[6]=%%g
          set row[7]=%%h
  )       
  
      echo !row[0]!,!row[2]!,!row[3]!,!row[4]!,!row[5]!,!row[6]! &gt;&gt;tmp.txt
          echo.
  )
  endlocal
  
  
  
  Test file:
  A1,B1,C1,D1,la la,,1
  A2,B2,C2,D2, ,fef 3,
  A3,B3,C3,D3,be be ,bo,bo 1
  A4,B4,C4,D4,tu tu,tu 7,881
  
  Output file:
  A1,C1,D1,la la,1, 
  A2,C2,D2, ,fef 3, 
  A3,C3,D3,be be ,bo,bo 1 
  A4,C4,D4,tu tu,tu 7,881 
  </code></pre>
  
  <p>I don't get why in the output file at the first line the ,, is eliminated and a <code>,</code> added at the end. Also I am wondering if there is a better way to do this.
  Thanks! </p>