use variable in command line batch file

Question

I use the following command in a batch file:

winscp sitename /command "get /filename.160313.tgz q:\localfolder\"

which downloads the file using winscp program.

What I'd like to do is have "160313" be automatically generated based on today's date.

How would I replace 160313 with such variable?

You'd need to show us the format in which your machine displays the variable %date%. — Magoo
– Magoo, Commented Mar 13, 2016 at 10:52

npocmaka · Accepted Answer · 2016-03-13 11:22:23Z

1

@echo off
for /f "tokens=2 delims==" %%a in ('wmic OS Get localdatetime /value') do set "dt=%%a"
set "YY=%dt:~2,2%" & set "YYYY=%dt:~0,4%" & set "MM=%dt:~4,2%" & set "DD=%dt:~6,2%"
set "HH=%dt:~8,2%" & set "Min=%dt:~10,2%" & set "Sec=%dt:~12,2%"

echo %YY%%MM%%DD%

winscp sitename /command "get /filename.%YY%%MM%%DD%.tgz q:\localfolder\"

answered Mar 13, 2016 at 11:22

npocmaka

57.8k19 gold badges162 silver badges199 bronze badges

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

Comments

user6017774 · Accepted Answer · 2016-03-13 10:32:22Z

0

 C:\Users\User>echo %date:/= %
 Sun 13 03 2016

or for no spaces

set var=%date:/=%

Else you can use substring extraction

set var=%date:~-4%

for the year. See set /?.

answered Mar 13, 2016 at 10:32

user6017774

1 Comment

user6017774 Over a year ago

I showed you how to get the year. Use generalisation to solve the rest of the problem. And your quickness of reply means you didn't read help.

Martin Prikryl · Accepted Answer · 2017-06-14 04:32:51Z

0

WinSCP has its own syntax for generating timestamped names:

WinSCP.com /command ... "get /filename.%%TIMESTAMP#YYMMDD%%.tgz q:\localfolder\"

See also Formatting timestamp in batch file.

answered Jun 14, 2017 at 4:32

Martin Prikryl

205k64 gold badges560 silver badges1.1k bronze badges

Collectives™ on Stack Overflow

use variable in command line batch file

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related