Home/ Questions/Q 11204
Next
Answered
computing
  • 8
Asked: 2021-12-07T11:17:18+00:00 In:

Solved Find Folder With Largest Number By Batch

  • 8

Hi,

I am trying to write a batch file to find the folder that has the largest number in its name.

i.e. I have 3 dummy folders with alphanumeric names in the directory
Prod110000
Prod112000
Prod114000

So it should find “Prod114000” for me. I’m trying to pull just the numbers part of the folder name so I can use GTR to compare – I am having troubles pulling the numbers part out of the batch variable (%%G) though because I can’t manipulate it.

I suspect there is also some problem in the “set latestdir=%%G” statement too.

What I (only) have right now is this:
g:
cd G:\xxxxxxxx

for /D %%G in (“Prod*”) do if %%G GTR %latestdir:~4,10% set latestdir=%%G

Thanks for the help!

Share

    1 Answer

    1. Best Answer
      Test this. Am not sure what you want to compare the folder name numbers with (or why). The script will extract the latest folder based on the folder name only, not actual creation or written time.

      Good luck.

      @echo off
cls
setlocal 

cd /d G:\xxxxxxxx

for /f "tokens=*" %%1 in ('dir /b /ad /on prod*') do (
    set latestdir=%%1
)

echo Latest directory name=%latestdir%
echo.
echo Numbers in latest directory name=%latestdir:~4%

      Please come back & tell us if your problem is resolved.

      • 0