I'm afraid You can't do that with the dir command alone. Do You mean DOS or NT (command.exe or cmd.exe)?
But if You combine it with the "FOR /F" You can extract the needed columns and order them as You want. Have a look at SS64.com Command line reference, an excellent site for explaining some of the most common scripting languages.
I'm not sure about the full path, maybe You would have to combine the command by using dir /s to get the directories, or perhaps tree.
I'm sure it's not THAT hard to find a command to create that list.
Thank you - it is helpful just to have had it confirmed that I haven't missed a DIR switch.
It just feels frustrating that output displayed through the GUI Windows Search program can't be output to file and can't be directly replicated through DIR (I'm using CMD.exe by the way).
I'm sure that lots of people have had the same requirement but my initial Google searches didn't find anything ideal so I was hoping that someone here would have a quick answer. I'll go back to searching or work something out for myself.
GM_AIX
---------- Post updated at 04:44 AM ---------- Previous update was at 04:43 AM ----------
Oh, one extra point...
In my particular case, the directory structure is in a Clearcase stream, so if anyone happened to know a ClearTool solution, that would be a viable alternative on this occasion.
No problems!
I often get frustrated about the shortcomings of "DOS". When I have a complicated script problem it often results in tweaks and workarounds and temporary files, fooling the shell with any number of %%% and """" (where nobody actually knows why it works, it just does, sometimes... also depending if it's in a bat/cmd-file or on an interactive command line) using dozens of programs, that so easily could have been solved with bash alone, possibly with a helper such as sort/grep/find/cut or whatever.
DIR /O:A will sort the list by last access time with the earliest time first. I presume you could then sort the files by name if rerquired after exporting them to Excel.
Assuming XP.
This must be done in a Batch File (.bat).
The first script is your exact requirement. The second script puts the timestamp in front of the filename which is more readable.
@echo off
REM list files with timestamp
REM Filename first then timestamp
for /R %%I in (*.*) do @echo %%~dpnxI %%~tI
@echo off
REM list files with timestamp
REM Timestamp first then name
for /R %%I in (*.*) do @echo %%~tI %%~dpnxI
Just for interest, there are techniques available from Excel if you don't mind a bit of VB programming. For example (but do check your Excel and Windows version and re-search the KB).
