Batch script to search & extract a string from a XML file

Question

I have an XML file like this:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<configuration>
    <messaging msg="otherfiles.xml" />
    <counter tes="01" />
    <gate address="192.168.1.1:12345" allowed="172.11.1.1"/>
</configuration>

The file name is test.xml test.xml.

And I have an bat file:

@echo OFF
set dir="D:\Test"
for /f "delims=" %%i in ('findstr /i /c:"address" %dir%\test.xml') do call :job "%%i"
goto :eof

:job
set line=%1
set line=%line:/=%
set line=%line:<=+%
set line=%line:>=+%
set line=%line:*+string+=%
set line=%line:+=&rem.%
echo.%line%>>%dir%\output.txt

:eof

I need output like this:

192.168.1.1:12345

Can anyone help me?

user7818749 · Accepted Answer · 2022-11-23 11:34:15Z

0

You do not need to use all this search and replace, if you use delims and tokens with for:

@echo off
set "Mydir=D:\Test"
for /f "tokens=1,2* delims==/" %%i in (
             'findstr /c:"address" "%Mydir%\test.xml"'
             ) do echo %%~j

see for /?, from cmd for full usage information.

Note! I changed your variable from %dir% to %Mydir% as it is not usually a good idea to name anything in batch the same as a system command.

answered Nov 23, 2022 at 11:34

user7818749

Sign up to request clarification or add additional context in comments.

2 Comments

Noval Juniardi Over a year ago

Thanks. How if I change xml to <gate address="192.168.1.1:12345" allowed="172.11.1.1"/> and save output to file?

user7818749 Over a year ago

have a look at my answer, here You have to be careful though as you have poison characters in the xml < and > which you need to ensure does not get translated as redirects.

Collectives™ on Stack Overflow

Batch script to search & extract a string from a XML file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related