Prev: Deleting Preview prefs?
Next: FileMaker Pro Advanced Creating Starter Solutions?
From: Salmon Egg on 28 Jun 2010 00:05
In article <x6TVn.7874$Z6.4078(a)edtnps82>, me(a)home.spamsucks.ca (Kir�ly)
wrote:

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

Unfortunately I do not know how to use Terminal. However, your clue and
method looks he lpful. You are also adding to my incentive to learn more
about Terminal.Thanks.

Bill

--
An old man would be better off never having been born.
From: =?ISO-8859-1?Q?Kir=E1ly?= on 28 Jun 2010 00:56
Salmon Egg <SalmonEgg(a)sbcglobal.net> wrote:
> Unfortunately I do not know how to use Terminal.

You open it, and type in the command I gave.

--
K.

Lang may your lum reek.
From: BreadWithSpam on 28 Jun 2010 01:00
Salmon Egg <SalmonEgg(a)sbcglobal.net> writes:

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

open the Terminal

ls -l /path/to/directory > ~/listing.txt

you now have a text file containign extended listing for the files in
that directory sitting in a txt file in your home directory. You may
open that text file in a spreadsheet.

For more information about the ls command, and additional options, do

man ls

as a shortcut so you don't have to type /path/to/directory, you can
simply drag the icon from the title bar of the window and drop it
into the Terminal.

--
Plain Bread alone for e-mail, thanks. The rest gets trashed.
From: JF Mezei on 28 Jun 2010 01:08
Michelle Steiner wrote:

> Actually, the suggestion to use terminal probably will work better,
> assuming that the terminal listings contain the specific data you want.

in the terminal window:

man ls

it will give you a whole slew of formatting options. You have have it
display just about any field you want. Within "man", you can use the
up/down arrows and the next page previous page keys to scroll. This is a
text window, not a GUI window.
From: Wes Groleau on 28 Jun 2010 01:13
On 06-27-2010 17:24, Salmon Egg 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.
>
> Can you do the same for the table display in Finder?

Open the (shudder) Terminal.

type the two letters
cd
followed by a space

drag the folder icon into the terminal

ensure the Terminal window has focus and tap return.

type this (six chars counting the space):
ls -la
and tap return

Select all the text you want

Menu: Shell -> Export selected text as ...

Change Saved Terminal Output to a more sensible filename

Go to Excel and Import that file. (Fixed column width)

Takes a while to say it, but it's really not hard to do.
--
Wes Groleau

Gaffes Can Be Deceiving
http://Ideas.Lang-Learn.us/WWW?itemid=610
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Deleting Preview prefs?
Next: FileMaker Pro Advanced Creating Starter Solutions?