使用批处理脚本在XML文件中增加属性值

Question

我正在尝试编辑xml文件并增加一个名为'pageindex'的属性值。

xml文件中的数据如下所示

?xml version="1.0" encoding="UTF-8"?>
<quer:query productCode="RC1700" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="Candidate" locale="en" alias="MainQuery" mode="T-XML" largegraph="true"
preventDuplicates="false" attributes="pageindex=1,pagingsize=350" 
xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:subQueries/><quer:projections>
<quer:projection><quer:field path="Number"/>
</quer:projection><quer:projection><quer:field path="FirstName"/> 

这是我创建的批处理脚本，但是值'1'没有增加。

@echo off
setlocal EnableExtensions DisableDelayedExpansion

rem // Define constants here:
set "_FILE=pagexml" & rem // (input file; `%~1` is the first argument)
set "_INI=<quer:query productCode="RC1700" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="Candidate" locale="en" alias="MainQuery" mode="T-XML" largegraph="true" preventDuplicates="false" attributes=" &
set "_TAG=pageindex=" & rem // (opening tag)

rem // Loop over all (non-empty) lines of the input file:
(for /F "usebackq delims=" %%L in ("%_FILE%") do (
rem // Store current line string:
set "LINE=%%L"
rem // Toggle delayed expansion to avoid troubles with `!`:
setlocal EnableDelayedExpansion
rem // Split off opening tag from line string:
set "TEST=!LINE:*%_TAG%=!"
rem // Check whether opening tag has been found:
if not "!TEST!"=="!LINE!" (
rem // Opening tag found, hence split off closing tag:
for /F "tokens=1* eol=, delims=, " %%S in ("!TEST!") do (
rem // Get extracted number and increment it:
set /A "NUM=%%S+1"
rem // Return rebuild line with incremented number:
echo( !_INI!!_TAG!!NUM!^,%%T
)
) else (
rem // Opening tag not found, hence return original line:
echo(!LINE!
)
endlocal
))>pageTmp.xml 


copy /v /y "pageTmp.xml" "page.xml"
del "pageTmp.xml"

这是我运行bat时得到的输出。你可以看到属性'pageindex'没有返回任何值。

?xml version="1.0" encoding="UTF-8"?>
<quer:query productCode="RC1700" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="Candidate" locale="en" alias="MainQuery" mode="T-XML" largegraph="true"
preventDuplicates="false" attributes="pageindex=,pagingsize=350" 
xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:subQueries/><quer:projections>
<quer:projection><quer:field path="Number"/>
</quer:projection><quer:projection><quer:field path="FirstName"/>

如何解决这个问题?这也是我第一次使用批处理脚本!

Answer 1

第一个问题是您的搜索字符串_TAG=pageindex=.
当在set "TEST=!LINE:*%_TAG%=!"中使用它时，结果是

==1,pagingsize=350"

等号被加倍，因为搜索表达式不能包含等号，等号总是用于分割搜索和替换部分。
搜索pageindex并替换为=

因此%%S包含==1,set /a NUM===1+1失败

您可以通过将

中的delims=,更改为delims=,=来解决它

for /F "tokens=1* eol=, delims=,= " %%S in ("!TEST!") do (