'Replace First two lines of file with (removing schema)' Thread RSS Feed

Replace First two lines of file with (removing schema)

Mon, 16 Apr 2012 04:44:36 -0700

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 “<scenarioFile>”

So changing

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<scenarioFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updateRec>
<ec>CME</ec>

To

<scenarioFile>
<updateRec>
<ec>CME</ec>

Since it is a batch file, you can show me how to do this to one file, and then I can copy paste the rest into the batch (I hope that makes sense)

The unwanted schema was added by Excel.

Thank you for your help.

Replace First two lines of file with (removing schema)

Sun, 13 May 2012 15:44:46 -0700

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%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1 > nul
del %temp%\newfile.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

Replace First two lines of file with (removing schema)

Sun, 13 May 2012 15:51:31 -0700

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%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1
del %temp%\newfile.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.

Replace First two lines of file with (removing schema)

Sun, 13 May 2012 15:54:55 -0700

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%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1
del %temp%\newfile.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.