Errors when calling powershell commands from cmd [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 8 years ago.

Improve this question

I'm trying to return value to my batch script. In powershell this script works fine:

PS> (Get-Date -Date "9.04.2017" -Uformat "%w.%Y-%m-%d").Replace("0.", "7.")
7.2017-04-09

When i try from batch:

for /f %%a in ('powershell ^(Get-Date -Uformat "%%w.%%Y-%%m-%%d"^).Replace^(^'0.^', ^'7.^'^)') do set datestamp=%%a
echo %datestamp%

I get errors, but this script works fine:

for /f %%a in ('powershell ^(get-date^).DayOfWeek') do set weekday=%%a
for /f %%a in ('powershell Get-Date -Uformat "%%u.%weekday%.%%Y-%%m-%%d"') do set datestamp=%%a
echo %datestamp%

What am I doing wrong?

also : I can't think of any reason why you would try to do this from batch? — bluuf
– bluuf, Commented Apr 10, 2017 at 12:50
I have a big batch script, where I need only one powershell call. Maybe later I''rewrite the script to powershell. — Antiokh
– Antiokh, Commented Apr 10, 2017 at 12:53

npocmaka · Accepted Answer · 2017-04-10 12:54:21Z

5

In order to avoid need of escaping single quotes use useback parameter.Put everything in double quotes to avoid need of escaping brackets (and mind that -UFormat also accepts single quotes for the format):

for /f "usebackq" %%a in (`"powershell (Get-Date -Uformat '%%w.%%Y-%%m-%%d').Replace('0.', '7.')"`) do set datestamp=%%a
echo %datestamp%

answered Apr 10, 2017 at 12:54

npocmaka

57.8k19 gold badges162 silver badges199 bronze badges

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

1 Comment

mklement0 Over a year ago

usebackq is a great idea, but I suggest wrapping only the (implied) -Command argument (the string containing the PowerShell commands) in "...":

for /f "usebackq" %%a in (`powershell -Command "(Get-Date -Uformat '%%w.%%Y-%%m-%%d').Replace('0.', '7.')"`) do set datestamp=%%a

. If you need to embed " chars. inside the command string, use \"" in Windows PowerShell (powershell.exe) or, more simply and robustly, "" in PowerShell [Core] 6+ (pwsh.exe).

Antiokh · Accepted Answer · 2017-04-10 12:55:17Z

2

I've found my mistake. I need to escape comma-character. Now it looks strange, but works.

for /f %%a in ('powershell ^(Get-Date  -Date "9.04.2017" -Uformat "%%w.%%Y-%%m-%%d"^).Replace^(^'0.^'^,^'7.^'^)') do set datestamp=%%a
echo %datestamp%

answered Apr 10, 2017 at 12:55

Antiokh

738 bronze badges

2 Comments

npocmaka Over a year ago

comma is a standard delimiter in batch files as long as <space>,<tab>,,,; and = and needs to be escaped in for loops.

mklement0 Over a year ago

To rephrase @npocmaka's helpful comment: all the characters mentioned function as argument separators.

Collectives™ on Stack Overflow

Errors when calling powershell commands from cmd [closed]

2 Answers 2

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Linked

Related