对于具有numpy / pandas的循环（迭代列标题）(For loops with numpy/pandas (iterating over column headers))

 如何使用Windows命令行环境查找和替换文件中的文本？ 列出了几个用于从命令行替换文件中的字符串的工具。 
 
 我喜欢免费的控制台工具xchang32.exe，因为它功能强大且非常易于使用。 
 
 我将XML文件的内容复制到一个文件中，并使用名称Test.xml保存它。 
 
 然后我执行了以下命令： 
 
xchang32.exe Test.xml "port=^34third^34 protocol" "port=^34newPort^34 protocol"
 
 该命令仅在文件中更改 
 
<Connector port="third" protocol="HTTP/1.1" SSLEnabled="..." /> 
 
 至 
 
<Connector port="newPort" protocol="HTTP/1.1" SSLEnabled="..." /> 
 
 ^34是双引号字符的转义序列" ，其具有十进制代码值34。 
 
 xchang32.exe /? 在命令提示符窗口中输入并执行此替换工具的输出帮助。 
 
 当然，您也可以使用引用主题中建议的任何其他方法。 您只需要在搜索中包含协议并替换字符串以仅修改应修改的端口号并忽略所有其他端口号。 仅使用Windows标准命令的解决方案更加困难，因为XML文件中的字符< ， >和"在命令行中具有特殊含义。 
 
 
 编辑： 
 
 当然知道在执行批处理文件时不知道文件中的当前端口号是一个重要的事实。 从最初的问题来看，这对我来说并不是很清楚。 这使得它更加困难。 
 
 一种解决方案是首先搜索现有端口值，一旦找到就进行替换。 
 
@echo off

rem Search in file for a line where first opening tag is
rem "Connector" which has as first attribute "port" and
rem one more attribute "protocol" and assign the value
rem of the attribute port to an environment variable.

for /F "tokens=1-4 delims==<     " %%A in (Test.xml) do (
    if "%%A"=="Connector" (
        if "%%B"=="port" (
            if "%%D"=="protocol" (
                set "PortNumber=%%~C"
                goto Replace
            )
        )
    )
)
echo Could not find the port value of interest.
goto :EOF

:Replace
xchang32.exe Test.xml "port=^34,%PortNumber%^34 protocol" "port=^34,%~1^34 protocol"
set "PortNumber="
 
 注意： 
 
 在使用以下命令后，在delims= on行之后有4个字符： 
 
 
 
 一个等号， 
 
 
 一个左尖括号， 
 
 
 一个水平制表符（不是浏览器显示的空格序列）和 
 
 
 单个空格字符。 
 
 
 分隔符的顺序很重要，否则命令行解释器会因语法错误而退出批处理脚本。 
 
 感兴趣的行将命令分为4个分隔符： 
 
 
 
 令牌1： Connector 
 
 
 令牌2： port 
 
 
 令牌3： "third" 
 
 
 令牌4： protocol 
 
 
 还有更多不感兴趣的代币。 
 
 
 这4个标记分配给循环变量A （标记名称）， B （第一个属性的名称）， C （第一个属性的值）和D （第二个属性的名称）。 
 
 变量A ， B和D的值用于检查是否找到了正确的行。 变量C的值在肯定检查时分配给环境变量，并删除周围的双引号。 然后通过跳转退出循环以替换部分批处理脚本。 
 
 再次使用免费工具xchang32.exe在文件中进行替换而不更改任何其他内容。 由于赋给属性端口的值是整数值，因此必须在第一个^34之后使用逗号让工具知道引用双引号字符的整数在何处结束。 
 
 有关在命令提示符窗口中执行命令的帮助，可以for /? 或help for 。 

How can you find and replace text in a file using the Windows command-line environment? lists several tools for replacing a string in a file from command line.
 
I like free console tool xchang32.exe as it is powerful and very easy to use.
 
I copied the content of your XML file into a file and saved it with name Test.xml.
 
Then I executed following command:
 
xchang32.exe Test.xml "port=^34third^34 protocol" "port=^34newPort^34 protocol"
 
That command changed in the file only
 
<Connector port="third" protocol="HTTP/1.1" SSLEnabled="..." /> 
 
to
 
<Connector port="newPort" protocol="HTTP/1.1" SSLEnabled="..." /> 
 
^34 is an escape sequence for double quote character " which has decimal code value 34.
 
xchang32.exe /? entered and executed in a command prompt window outputs help for this replace tool.
 
Of course you could use also any other method suggested in the referenced topic. You just need to include protocol in search and replace string to modify just the port number which should be modified and ignore all other. Solutions using only Windows standard commands are more difficult because of the characters <, > and " in the XML file which have a special meaning on command line.
 
 
EDIT:
 
It is of course an important fact to know that the current port number in file is not known on executing the batch file. That was not really clear for me from the initial question. This makes it more difficult.
 
One solution would be to first search for existing port value and once found do the replace.
 
@echo off

rem Search in file for a line where first opening tag is
rem "Connector" which has as first attribute "port" and
rem one more attribute "protocol" and assign the value
rem of the attribute port to an environment variable.

for /F "tokens=1-4 delims==<     " %%A in (Test.xml) do (
    if "%%A"=="Connector" (
        if "%%B"=="port" (
            if "%%D"=="protocol" (
                set "PortNumber=%%~C"
                goto Replace
            )
        )
    )
)
echo Could not find the port value of interest.
goto :EOF

:Replace
xchang32.exe Test.xml "port=^34,%PortNumber%^34 protocol" "port=^34,%~1^34 protocol"
set "PortNumber="
 
Attention:
 
There are 4 characters after delims= on line with command for:
 
 
 
an equal sign,
 
 
a left angle bracket,
 
 
a horizontal tab character (not a sequence of spaces as browser displays) and
 
 
a single space character.
 
 
The order of the delimiter characters is important as otherwise command line interpreter would exit batch script because of a syntax error.
 
The line of interest is split up by command for with those 4 delimiters into:
 
 
 
token 1: Connector
 
 
token 2: port
 
 
token 3: "third"
 
 
token 4: protocol
 
 
and more tokens not of interest.
 
 
Those 4 tokens are assigned to the loop variables A (tag name), B (name of first attribute), C (value of first attribute) and D (name of second attribute.
 
The values of variables A, B and D are used to check if the right line was found. The value of variable C is assigned on positive check to an environment variable with removing the surrounding double quotes. Then the loop is exited with a jump to replace part of the batch script.
 
Again free tool xchang32.exe is used to make the replacement in the file without changing anything else. As the value assigned to attribute port is an integer value, it is necessary to use a comma after first ^34 to let the tool know where the integer number referencing the double quote character ends.
 
For help on command for execute in a command prompt window either for /? or help for.