Windows batch file - replace a string in an XML file

Question

I have the following XML file:

<?xml version="1.0"?>
    <configuration>
      <startup>
        <supportedRuntime version="v2.0.50727"/>
      </startup>
      <appSettings>
        <add key="Name1" value="Value1"/>
        <add key="Name2" value="Value2"/>
        <add key="Name3" value="Value3"/>
      </appSettings>
      <runtime>
        <legacyUnhandledExceptionPolicy enabled="true"/>
      </runtime>
    </configuration>

I need to replace "Value2" to "ServerName" using Windows Batch file programming.

Could anybody help one as I am new to Windows Batch programming?

Any specific reason why it HAS to be a bat file, and not a small C program? — Radu, Nov 02 '11 at 06:59
Look at this post1 in stackoverflow which has the required answer. http://stackoverflow.com/questions/60034/how-can-you-find-and-replace-text-in-a-file-using-the-windows-command-line-envir — Raghuram, Nov 02 '11 at 07:04
DOS is an operating system that hasn't been in active use for a very long time. Your question is in fact about *Windows* batch scripting. Even though it originated in DOS times, it was Windows (esp. Windows NT) where it acquired a lot of additional features. — Andriy M, Nov 02 '11 at 14:38

score 3 · Accepted Answer · answered Nov 18 '11 at 20:47

Batch will have trouble with <, >, ^ and & characters. This will work, but a JScript/VBScript script (like is referenced in one of the comments) is a much better solution.

Change "ORIGINAL" to the text being searched for, and "REPLACE" to the new text. I recommend for Windows scripting to learn JScript.

@echo off
for /f "tokens=* delims=" %%f in ('type sometext.txt') do CALL :DOREPLACE "%%f"

GOTO :EOF
:DOREPLACE
SET INPUT=%*
SET OUTPUT=%INPUT:ORIGINAL=REPLACE%

for /f "tokens=* delims=" %%g in ('ECHO %OUTPUT%') do ECHO %%~g>>out.txt

EXIT /b

:EOF

score 0 · Answer 2 · answered Nov 28 '20 at 15:53

Please use a tool like xmlstarlet that's designed to edit xml:

xmlstarlet ed -u "//add[@value='Value2']/@value" -v ServerName input.xml
<?xml version="1.0"?>
<configuration>
  <startup>
    <supportedRuntime version="v2.0.50727"/>
  </startup>
  <appSettings>
    <add key="Name1" value="Value1"/>
    <add key="Name2" value="ServerName"/>
    <add key="Name3" value="Value3"/>
  </appSettings>
  <runtime>
    <legacyUnhandledExceptionPolicy enabled="true"/>
  </runtime>
</configuration>

Windows batch file - replace a string in an XML file

2 Answers2

Linked