OPen terminal
type cd at the command prompt
Drag the desired folder onto the terminal and that will give you the directory path
HIT return
Then copy this command into terminal
That will copy the Filename, Creation Date and Size as a semicolon separated text file to the clipboard
paste the text into a text editor and save it with the csv extension
open the file in excel and make sure semicolon is set as the separater
Thanks for these instructions. I did just that. CD, then I dragged the folder into terminal and it typed the path out for me. I hit return and it said:
Last login: Wed Jul 10 11:20:31 on ttys000
Editing-West-8:~ rachel$ cd/Volumes/Alzheimer\'s\ Assn/Alz\ Drive\ Folder/0_Organized\ by\ Year/2008/Alz_Champions08/Footage/Leeza\ Gibbons
-bash: cd/Volumes/Alzheimer's Assn/Alz Drive Folder/0_Organized by Year/2008/Alz_Champions08/Footage/Leeza Gibbons: No such file or directory
Then I typed in that second code you gave me....
ls -lT | \
awk '{print "\""$10"\""";""\""$6" "$7", "$9"\""";""\""$5"\""}' \
| pbcopy
I hit return. Then I went into TextEditor and pasted Paste and I got this:
"";" , ";""
"Applications";"Jun 26, 2013";"68"
"Desktop";"Jul 10, 2013";"306"
"Documents";"Jun 27, 2013";"306"
"Downloads";"Jul 9, 2013";"510"
"Library";"Jun 21, 2013";"1530"
"Movies";"Jun 10, 2013";"102"
"Music";"Jul 2, 2013";"136"
"Pictures";"Jul 3, 2013";"170"
"Public";"Jun 10, 2013";"136"
"homeDirectory.csv";"Jul 10, 2013";"145"
This is close to what I want, only this is not the right location, obviously. You can tell that the command got confused about the location when I dragged in the folder and it told me "No such file or directory". I thought maybe its giving me issues because its on a server? So I dragged that folder to the desktop and tried again:
Editing-West-8:~ rachel$ cd/Users/rachel/Desktop/Leeza\ Gibbons
-bash: cd/Users/rachel/Desktop/Leeza Gibbons: No such file or directory
Editing-West-8:~ rachel$
....then I typed in that command of yours... did the paste into text edit.... and got the same thing:
"";" , ";""
"Applications";"Jun 26, 2013";"68"
"Desktop";"Jul 10, 2013";"272"
"Documents";"Jun 27, 2013";"306"
"Downloads";"Jul 9, 2013";"510"
"Library";"Jun 21, 2013";"1530"
"Movies";"Jun 10, 2013";"102"
"Music";"Jul 2, 2013";"136"
"Pictures";"Jul 10, 2013";"204"
"Public";"Jun 10, 2013";"136"
"homeDirectory.csv";"Jul 10, 2013";"145"
Why isn't it working for me?