title: How to create batch file to remove double quotes from particular column from csv file
body: <p>How to create batch file to remove double quotes from particular column from csv file </p>
  
  <p>Input csv file:</p>
  
  <pre><code>"DocumentType","Company","Division","SeasonYear","Style"
  "832","XYZ","S17","2017","S"
  "832","XYZ","S17","2017","M"
  </code></pre>
  
  <p>I want to remove double quotes from column 1 where values will be DocumentType in header (first record) and 832 for remaining records.</p>
  
  <p>Expected result should be:</p>
  
  <pre><code>DocumentType,"Company","Division","SeasonYear","Style"
  832,"XYZ","S17","2017","S"
  832,"XYZ","S17","2017","M"
  </code></pre>
  
  <p>I tried with below batch script but it replaces all double quotes in file.</p>
  
  <pre><code>@echo off
  setlocal EnableDelayedExpansion
  
  set FileIn=out.csv
  set FileOut=in2.csv
  
  (
      for /F "usebackq tokens=*" %%A in ("%FileIn%") do (
      set Line=%%A
      set Line=!Line:"=!
      for /L %%B in (1,1,20) do (
          set Line=!Line: ,=,!
          set Line=!Line:, =,!
      )
      echo.!Line!
      )
   ) &gt; "%FileOut%"
  </code></pre>
  
  <p>Please advise.</p>