User:WorkExp2017

Monday

Wiki Reference Card: Wiki PDF My assigned project for Monday was to name and categorize image files of embryo's onto an excel spreadsheet while listing and duplication of the files and images. These images include highly detailed photographs of the original

1. In order to copy image file names onto an Excel spread sheet you must first open the command prompt then edit the selected drive to match the current drive the hard drive is located.
2. This done by adding; d: to C:/Users/Unsw.Unsw-23098 then pressing the enter key. This will for example change the drive location to drive d.
3. Then proceed to type dir which will give you the directory view.
4. You then must find the folder that contains the file names you wish to copy then type cd (change directory) then the file name.
5. Press the enter key and then type once again dir which will bring up the list of all the file names in the selected folder.
6. Type dir then space > then create a name for the new filenew file.txtwhich will transfer all the names into a text file.
7. Finally open up the folder location and open the text file then select delimited, tab, space options then enter. after auto fitting the excel spreadsheet should have the entire list of names. For small amounts of folders just right click, rename then copy and paste.

This link depicts each step taken. [1]

The majority of hard drives where categorized on an excel spreadsheet and i began to identify duplicate folders on a separate spreadsheet. Folders from the hard drives containing the images have had some files and even hard drives completely duplicated and it is imperative they are located.