08 | Januar | 2014

Windows Batch zum Erstellen einer Liste mit den Dateinamen eines Verzeichnisses als CSV-Datei:

@echo off

setlocal EnableDelayedExpansion
SET /P YYYY=Jahresscheibe (YYYY): 
SET /A FCOUNT=0
(
  echo generated by create-filelist.bat [%DATE%] > %YYYY%.info.csv
  echo Name;File Size;Modified;Created >> %YYYY%.info.csv
  for %%f in (*.zip) do (
    set "name=%%~nxf"
    if not "!name!"=="%~nx0" (
      set "mtime=%%~tf"
	  set "fsize=%%~zf"
      for /f "tokens=1-3" %%d in (
        'dir /t:c "!name!" ^| find /i "!name!"'
      ) do set "ctime=%%~d %%~e"
	  if not "x!mtime:%YYYY%=!"=="x!mtime!" (
		SET /a FCOUNT+=1
		echo Processing !FCOUNT! !name! $$$ !mtime!
		echo !name!;!fsize!;!mtime!;!ctime! >> %YYYY%.info.csv
	  ) else (
		echo Ignore !name! $$$ !mtime!
	  )
    )
  )
  echo. >> %YYYY%.info.csv
  echo !FCOUNT! files listed in %YYYY% >> %YYYY%.info.csv
)

@echo off

setlocal EnableDelayedExpansion

SET /P YYYY=Jahresscheibe (YYYY):

SET /A FCOUNT=0

(

echo generated by create-filelist.bat [%DATE%] > %YYYY%.info.csv

echo Name;File Size;Modified;Created >> %YYYY%.info.csv

for %%f in (*.zip) do (

set "name=%%~nxf"

if not "!name!"=="%~nx0" (

set "mtime=%%~tf"

set "fsize=%%~zf"

for /f "tokens=1-3" %%d in (

'dir /t:c "!name!" ^| find /i "!name!"'

) do set "ctime=%%~d %%~e"

if not "x!mtime:%YYYY%=!"=="x!mtime!" (

SET /a FCOUNT+=1

echo Processing !FCOUNT! !name! $$$ !mtime!

echo !name!;!fsize!;!mtime!;!ctime! >> %YYYY%.info.csv

) else (

echo Ignore !name! $$$ !mtime!

)

echo. >> %YYYY%.info.csv

echo !FCOUNT! files listed in %YYYY% >> %YYYY%.info.csv

)

M	D	M	D	F	S	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

realraum

Bloggen in realen Räumen

Archiv für den Tag: Januar 8, 2014

Dateinamenliste mittels Batch generieren