Command Line Basics
Go to command prompt
-
Click on Start button
-
Choose RUN option
-
At open prompt, type cmd
-
Press okay
-
Command window appears
Enter command lines to output directory of files to txt file
-
Open main directory (drag to cmd window)
-
Change directory (cd) to desired folder
-
Type in command: dir /s >myoutput.txt
-
Press enter
-
File is stored in directory given above
Figure 1: Command Prompt window
Figure 2: Output file
Note: The Windows command will put the output file into the current working directory.
Variations: DIR *.tif /s /b /a-d >tifflist.txt
- Will give list of tiff files (but not directories, /a-d) in all subdirectories (/s), listed in bare (i.e., simple filename only, /b) format, saved in a new file called tifflist.txt.
Open text file in excel
-
Open excel
-
Select File Open command
-
Navigate to folder where txt file was sent
-
Change file type to text
-
Select file
-
Press Open
-
Text Wizard will pop up
Text Wizard
-
Select Delimited option and press Next button
-
Under Delimiters place check mark next to Space (lines will appear, use scroll bars to view how text will be split out)
-
Press finished button
Data is displayed with columns for date of file, time of file, file size and file name…
… data for each sub folder is also included…
Tip: clean up data in the overall file by any combination of methods such as sorting, filtering, grouping or using formulas to group by object id
Comments (0)
You don't have permission to comment on this page.