如何在批处理文件的powershell命令中包含“&"号? [英] How do I include ampersands in a powershell command in a batch file?

问题描述

我正在尝试通过批处理文件下载Google表格.这有效:

I am trying to download a Google sheet via a batch file. This works:

powershell -Command "Invoke-WebRequest https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/export?exportFormat=tsv -OutFile output.tsv"

当我通过添加& gid = 1234指定所需的工作表/标签时，这会中断:

When I specify which sheet/tab I want by adding &gid=1234, this breaks:

powershell -Command "Invoke-WebRequest https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/export?exportFormat=tsv&gid=1234 -OutFile output.tsv"

错误是:

不允许使用&字符. &运算符保留 供将来使用；用与引号将双引号(&")括起来 将其作为字符串的一部分传递.

The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.

如何将&符括在引号中而不破坏Command参数的外部引号?

How do I wrap the ampersand in quotes without breaking the outer quotes for the Command parameter?

推荐答案

传递给powershell -Command的"..."字符串中嵌入的URL也必须加上引号，因为 > unquoted &对PowerShell也具有特殊的意义(尽管在Windows PowerShell中，当前仅保留供将来使用；在PowerShell Core 中，可以在位置后使用).来将命令作为后台作业运行.)

The URL embedded inside the "..." string passed to powershell -Command must be quoted too, because an unquoted & has special meaning to PowerShell too (though in Windows PowerShell it is currently only reserved for future use; in PowerShell Core it can be used post-positionally to run a command as a background job).

最简单的选项是使用嵌入式'...'引号，如 Olaf 所建议，因为'字符.不需要在"..."内转义. PowerShell中的'...'字符串是 literal 字符串，在这种情况下，考虑到URL不包含变量引用，就可以了.

The simplest option is to use embedded '...' quoting, as suggested by Olaf, because ' chars. don't need escaping inside "...". '...' strings in PowerShell are literal strings, which is fine in this case, given that the URL contains no variable references.

powershell -Command "Invoke-WebRequest 'https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/export?exportFormat=tsv&gid=1234' -OutFile output.tsv"

如果需要对字符串内插使用嵌入的"..."引号，请使用\" (原文如此)转义嵌入的(")字符. (请注意，在内部 PowerShell中，您需要使用`"或""代替):

If embedded "..." quoting is needed for string interpolation, use \" (sic) to escape the embedded (") chars. (note that inside PowerShell, you'd need to use `" or "" instead):

powershell -Command "Invoke-WebRequest \"https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/export?exportFormat=tsv&gid=1234\" -OutFile output.tsv"

这篇关于如何在批处理文件的powershell命令中包含“&"号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！