Replace First two lines of file with (removing schema)

Newfie_Lover

I am having a bear of a time getting a batch file to delete the first two lines of every file and replace them with a file of the same name and

skorpio07

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%
ewfile.tmp
if %%a==^ >>%temp%
ewfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%
ewfile.tmp
)
copy /y %temp%
ewfile.tmp %1 > nul
del %temp%
ewfile.tmp

now you can run this from the command prompt:
for %a in (*.ext) do changelines %a

replace *.ext with the wildcard of your excel files

skorpio07

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%
ewfile.tmp
if %%a==^ >>%temp%
ewfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%
ewfile.tmp
)
copy /y %temp%
ewfile.tmp %1
del %temp%
ewfile.tmp

now from the command line, do this:
for %a in (*.ext) do changelines %a

replace *.ext with the filename and type of your excel files.

skorpio07

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%
ewfile.tmp
if %%a==^ >>%temp%
ewfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%
ewfile.tmp
)
copy /y %temp%
ewfile.tmp %1
del %temp%
ewfile.tmp

now from the command line, do this:
for %a in (*.ext) do changelines %a

replace *.ext with the filename and type of your excel files.