• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Finally, you can manage your Google Docs, uploads, and email attachments (plus Dropbox and Slack files) in one convenient place. Claim a free account, and in less than 2 minutes, Dokkio (from the makers of PBworks) can automatically organize your content for you.

View
 

Extract filenames and file sizes

Page history last edited by Monica 8 years, 1 month ago Saved with comment

Command Line Basics

 


 

Go to command prompt

  1. Click on Start button

  2. Choose RUN option

  3. At open prompt, type cmd

  4. Press okay

  5. Command window appears

 

 

Enter command lines to output directory of files to txt file

  1. Open main directory (drag to cmd window)

  2. Change directory (cd) to desired folder

  3. Type in command: dir /s >myoutput.txt

  4. Press enter

  5. 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

  1. Open excel

  2. Select File Open command

  3. Navigate to folder where txt file was sent

  4. Change file type to text

  5. Select file

  6. Press Open

  7. Text Wizard will pop up

 

 

Text Wizard

  1. Select Delimited option and press Next button

 

 

  1. Under Delimiters place check mark next to Space (lines will appear, use scroll bars to view how text will be split out)

 

  1. 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…

 

  • Save file as excel type.

 

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.