DosTips.com

Code: Select all

@echo off &setlocal DisableDelayedExpansion
set "src=input.csv"
set "dst=missing.txt"

set "last="
>"%dst%" (
  for /f "delims=" %%i in ('sort /+27 "%src%"') do (
    if not defined last (
      set "last=%%i"
    ) else (
      set "row=%%i"
      setlocal EnableDelayedExpansion
      set /a "nxt=1!last:~26,6!+1,bfr=1!row:~26,6!-1"
      for /l %%j in (!nxt! 1 !bfr!) do (
        set "missing=%%j"
        echo XX19!missing:~1!
      )
      endlocal
      set "last=%%i"
    )
  )
)

Code: Select all

@echo off
setlocal EnableDelayedExpansion

rem Load numbers in a list and get the max
set "list= "
set "max=0"
for /F %%a in (input.txt) do (
   set "line=%%a"
   set /A "num=1!line:~26,6!-1000000"
   set "list=!list!!num! "
   if !num! gtr !max! set "max=!num!"
)

rem Show missing numbers from 1..max
for /L %%i in (1,1,%max%) do (
   if "!list: %%i =!" equ "%list%" (
      set /A "num=1000000+%%i"
      echo XX19!num:~1!
   )
)