## Determine lowest & highest number from column

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Message
Author
SIMMS7400
Posts: 446
Joined: 07 Jan 2016 07:47

### Determine lowest & highest number from column

Hi Folks -

What is the easiest way to determine the lowest and highest number from a specific column? Is it JSORT?

I have a csv file with (3) columns. Column (2) is the column I need to check and the numbers will range from 01 to 12.

Example:
State,01,2018
State,03,2018
State,05,2018
State,01,2019
State,09,2018
State,10,2018
State,12,2018
State,10,2019
Thanks!

SIMMS7400
Posts: 446
Joined: 07 Jan 2016 07:47

### Re: Determine lowest & highest number from column

I arrived at this solution, although I'm not sure if it's as efficient as it can be:

Code: Select all

``````@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION

(
FOR %%F IN ("*.csv") DO (

REM Sort PERIOD Column in reverse order to get MAX value
SET "MAX="
SET "MIN="
FOR /F "tokens=2,3 delims=," %%A IN ('SORT /R "%%F"') DO (
IF NOT DEFINED MAX (
SET "MAX=%%A"
SET "MAXYR=%%B"
echo Period = !MAX!
echo Year = !MAXYR!
)
)
REM Sort PERIOD Column in regular order to get MIN value
FOR /F "tokens=2,3 delims=," %%A IN ('SORT "%%F"') DO (
IF NOT DEFINED MIN (
SET "MIN=%%A"
SET "MINYR=%%B"
echo Period = !MIN!
echo Year = !MINYR!
)
)
)
)

pause``````
Any thoughts?