Windows batch to loop through the files in the folder and parse the file name

Question

How do I loop through the files in the folder and parse the portion of the file name and store it in a variable + echo?

Folder contains following files and need to pull out the year:

Actual2015.txt
Actual2016.txt

What I tried:

for %%f in (*.txt) do (
set year=%%f:~7,4%
echo %year%
)

result should be:

2014

2015

npocmaka · Accepted Answer · 2017-02-10 21:21:52Z

2

setlocal enableDelayedExpansion
for %%f in (*.txt) do (
  set fname=%%nf
  set year=!fname:~6,4!
  echo !year!
)

answered Feb 10, 2017 at 21:13

npocmaka

57.8k19 gold badges162 silver badges199 bronze badges

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

1 Comment

Missing the tilde.

Squashman · Accepted Answer · 2017-02-11 00:40:44Z

1

Or you can take the last 4 characters of the file name if you know that last 4 are what you want.

@echo off
setlocal enableDelayedExpansion
for %%f in (*.txt) do (
  set fname=%%~nf
  set year=!fname:~-4!
  echo !year!
)
pause

answered Feb 11, 2017 at 0:40

Squashman

14.4k5 gold badges30 silver badges38 bronze badges