Prev: Deleting Preview prefs?
Next: FileMaker Pro Advanced Creating Starter Solutions?
From: Salmon Egg on 27 Jun 2010 17:24
Suppose I have a Finder window that gives a listing of files in a
folder. Is there a way for me to get that listing and pasting it into a
spreadsheet such as Excel? I am using the latest version of Snowleopard.

If I select all of the window, copy, and then paste into Excel, I merely
get a list of the file names. That is all that shows in the clipboard.

Can you do the same for the table display in Finder?

Bill

--
An old man would be better off never having been born.
From: Barry Margolin on 27 Jun 2010 21:41
In article
<michelle-D47993.18114327062010(a)62-183-169-81.bb.dnainternet.fi>,
Michelle Steiner <michelle(a)michelle.org> wrote:

> In article <SalmonEgg-1DF36B.14244127062010(a)news60.forteinc.com>,
> Salmon Egg <SalmonEgg(a)sbcglobal.net> wrote:
>
> > Suppose I have a Finder window that gives a listing of files in a
> > folder. Is there a way for me to get that listing and pasting it into a
> > spreadsheet such as Excel? I am using the latest version of Snowleopard.
> >
> > If I select all of the window, copy, and then paste into Excel, I merely
> > get a list of the file names. That is all that shows in the clipboard.
>
> Exactly what do you want if you don't want the file names?

I'm guessing: all the other columns that the Finder displays, such as
modification time, kind, size.

--
Barry Margolin, barmar(a)alum.mit.edu
Arlington, MA
*** PLEASE post questions in newsgroups, not directly to me ***
*** PLEASE don't copy me on replies, I'll read them in the group ***
From: =?ISO-8859-1?Q?Kir=E1ly?= on 27 Jun 2010 21:42
Salmon Egg <SalmonEgg(a)sbcglobal.net> wrote:
> Suppose I have a Finder window that gives a listing of files in a
> folder. Is there a way for me to get that listing and pasting it into a
> spreadsheet such as Excel? I am using the latest version of Snowleopard.
>
> If I select all of the window, copy, and then paste into Excel, I merely
> get a list of the file names. That is all that shows in the clipboard.

Finder is a bad tool to use for this. Terminal works better:

ls -la /path/to/folder > ~/Desktop/list.txt

Look for a file "list.txt" on your Desktop, open with TextEdit, copy the
info and paste.

When typing the command, You can, instead of typing out the whole path
to the file, simply drag the folder into the Terminal window, press the
spacebar, and then continue typing the rest of the command.

--
K.

Lang may your lum reek.
From: Salmon Egg on 27 Jun 2010 23:53
In article
<michelle-D47993.18114327062010(a)62-183-169-81.bb.dnainternet.fi>,
Michelle Steiner <michelle(a)michelle.org> wrote:

> Exactly what do you want if you don't want the file names?

I do want the file names! I want other information as well so that I can
tell which files are newer than others with the same name. I can combine
the two lists of files, sort them, and select which files to keep and
which to delete.

Bill

--
An old man would be better off never having been born.
From: AES on 27 Jun 2010 23:57
> > > Suppose I have a Finder window that gives a listing of files in a
> > > folder. Is there a way for me to get that listing and pasting it into a
> > > spreadsheet such as Excel? I am using the latest version of Snowleopard.

Print Window from Searchware Solutions (advanced version) will capture a
selected list of the columns in a Finder window to a text file. Should
be possible to get it into an Excel file from there.
 |  Next  |  Last
Pages: 1 2 3
Prev: Deleting Preview prefs?
Next: FileMaker Pro Advanced Creating Starter Solutions?