Export search results

If you use the "find" search system under "start," you get a list of files.
How can that list be exported to an Excel spreadsheet? ...or printed out?

I have an IBM ThinkPad A20m 2820 running Windows SE.

Phil James

"Phil James" wrote in message
...

If you use the "find" search system under "start," you get a list of
files.
How can that list be exported to an Excel spreadsheet? ...or printed out?

Make use of
/ Options / Save Results
(and provide a TXT or all-ASCII filename.)

Don Phillipson
Carlsbad Springs
(Ottawa, Canada)

Use the DIR command in a Command prompt. Only drawback is that the resulting
file is not TAB separated and is not quickly, easily, imported into Excel.
For that purpose, you'd probably need a third-party app (don't think it can
be done with any basic Windows apps.)

***************************************
Displays a list of files and subdirectories in a directory.

DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
[/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]

[drive:][path][filename]
Specifies drive, directory, and/or files to list.
(Could be enhanced file specification or multiple filespecs.)
/P Pauses after each screenful of information.
/W Uses wide list format.
/A Displays files with specified attributes.
attributes D Directories R Read-only files
H Hidden files A Files ready for archiving
S System files - Prefix meaning not
/O List by files in sorted order.
sortorder N By name (alphabetic) S By size (smallest first)
E By extension (alphabetic) D By date & time (earliest
first)
G Group directories first - Prefix to reverse order
A By Last Access Date (earliest first)
/S Displays files in specified directory and all subdirectories.
/B Uses bare format (no heading information or summary).
/L Uses lowercase.
/V Verbose mode.
/4 Displays year with 4 digits (ignored if /V also given).

Switches may be preset in the DIRCMD environment variable. Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.
************************************************** *

As you can see, this DIR command can be used to locate specific files. To
pipe the results to a text file, at the end of whatever command you use add:
"[path]find_results.txt" (without quotes) where [path] (without brackets)
is the directory you want to place the results file in, and "find_results"
is the name of the file.

For best results, you should start in the root of the drive you are
searching. To do this, use the CD (change directory) command:
cd c:\

For a different drive, just type "d:", "e:" (without quotes), etc., followed
by enter. No need for the CD part.

Examples:
To locate all files named "*.doc", looking in the entire C:\ drive, and save
the results to C:\Find_DOC.txt
dir *.doc /S C:\Find_DOC.txt

To restrict the same search to C:\My Documents:
dir "C:\my documents\*.doc" /S C:\Find_DOC.txt

Note that whenever a path and/or filename includes any spaces, you must
enclose the entire path in "quotation marks".

To do that same search looking *only* in My Documents, but not sub-folders,
leave out the /S switch.
dir "C:\my documents\*.doc" C:\Find_DOC.txt

For this purpose, the /W and /P switch are not useful. However, the rest can
come in handy.

--
Gary S. Terhune
MS MVP Shell/User
http://grystmill.com/articles/cleanboot.htm
http://grystmill.com/articles/security.htm

"Phil James" wrote in message
...

If you use the "find" search system under "start," you get a list of
files.
How can that list be exported to an Excel spreadsheet? ...or printed out?

I have an IBM ThinkPad A20m 2820 running Windows SE.

Phil James

That is all well & good, really. HOWEVER, after many months of
puzzlement, I found out the hard way that "/S" won't reach into a Hidden
or a System folder...

C:\dir c:\Autoexec.bat /s /a
Directory of C:\
AUTOEXEC BAT 557 02-24-05 1:17a AUTOEXEC.BAT
1 file(s) 557 bytes

Directory of C:\WINDOWS\TEMP
AUTOEXEC BAT 1,103 04-23-99 10:22p AUTOEXEC.BAT
1 file(s) 1,103 bytes

Total files listed:
2 file(s) 1,660 bytes

....BUT, I have one in...

C:\dir C:\system.sav\autoexec.bat
Directory of C:\system.sav
AUTOEXEC BAT 251 11-15-99 2:36p autoexec.bat
1 file(s) 251 bytes

...., which is attributed Hidden. (System also would do it.)...

C:\attrib C:\System.sav
H SYSTEM.SAV C:\system.sav

That is a sad "feature" of DOS, as I do have 11 directories attributed
System...

C:\dir /s /ads
....snip
Total files listed:
11 dir(s) 6,701.66 MB free

....And 34 directories that are Hidden...

C:\dir /s /adh
Total files listed:
34 dir(s) 6,701.66 MB free


--
Thanks or Good Luck,
There may be humor in this post, and,
Naturally, you will not sue,
should things get worse after this,
PCR

"Gary S. Terhune" wrote in message
...
| Use the DIR command in a Command prompt. Only drawback is that the
resulting
| file is not TAB separated and is not quickly, easily, imported into
Excel.
| For that purpose, you'd probably need a third-party app (don't think
it can
| be done with any basic Windows apps.)
|
| ***************************************
| Displays a list of files and subdirectories in a directory.
|
| DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
| [/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]
|
| [drive:][path][filename]
| Specifies drive, directory, and/or files to list.
| (Could be enhanced file specification or multiple
filespecs.)
| /P Pauses after each screenful of information.
| /W Uses wide list format.
| /A Displays files with specified attributes.
| attributes D Directories R Read-only files
| H Hidden files A Files ready for
archiving
| S System files - Prefix meaning not
| /O List by files in sorted order.
| sortorder N By name (alphabetic) S By size (smallest
first)
| E By extension (alphabetic) D By date & time
(earliest
| first)
| G Group directories first - Prefix to reverse
order
| A By Last Access Date (earliest first)
| /S Displays files in specified directory and all
subdirectories.
| /B Uses bare format (no heading information or summary).
| /L Uses lowercase.
| /V Verbose mode.
| /4 Displays year with 4 digits (ignored if /V also given).
|
| Switches may be preset in the DIRCMD environment variable. Override
| preset switches by prefixing any switch with - (hyphen)--for example,
/-W.
| ************************************************** *
|
| As you can see, this DIR command can be used to locate specific files.
To
| pipe the results to a text file, at the end of whatever command you
use add:
| "[path]find_results.txt" (without quotes) where [path] (without
brackets)
| is the directory you want to place the results file in, and
"find_results"
| is the name of the file.
|
| For best results, you should start in the root of the drive you are
| searching. To do this, use the CD (change directory) command:
| cd c:\
|
| For a different drive, just type "d:", "e:" (without quotes), etc.,
followed
| by enter. No need for the CD part.
|
| Examples:
| To locate all files named "*.doc", looking in the entire C:\ drive,
and save
| the results to C:\Find_DOC.txt
| dir *.doc /S C:\Find_DOC.txt
|
| To restrict the same search to C:\My Documents:
| dir "C:\my documents\*.doc" /S C:\Find_DOC.txt
|
| Note that whenever a path and/or filename includes any spaces, you
must
| enclose the entire path in "quotation marks".
|
| To do that same search looking *only* in My Documents, but not
sub-folders,
| leave out the /S switch.
| dir "C:\my documents\*.doc" C:\Find_DOC.txt
|
| For this purpose, the /W and /P switch are not useful. However, the
rest can
| come in handy.
|
| --
| Gary S. Terhune
| MS MVP Shell/User
| http://grystmill.com/articles/cleanboot.htm
| http://grystmill.com/articles/security.htm
|
| "Phil James" wrote in message
| ...
|
| If you use the "find" search system under "start," you get a list of
| files.
| How can that list be exported to an Excel spreadsheet? ...or
printed out?
|
| I have an IBM ThinkPad A20m 2820 running Windows SE.
|
| Phil James
|
|
|
|
|

Thanks for reminding me. Yes, the default is to *not* include files with H
and/or S attributes. Always has been thus with the DIR command. To get all
of them, you need to do one search w/o any attributes included, then one for
H-only, then one for S-only, and finally one for H+S. These last three lists
will necessarily include duplications. You'd want to merge the lists to get
those with *only* H, *only* S and H+S. But as noted (I think I noted it) the
output is not really good for putting into Excel without first running a
script that would properly convert the results to a tab-delineated CSV file.
I've done similar things before, (specifically recall converting a
collection of HTML database output records to a remerged CSV file.) Might
even have the scripts around here somewhere, only needing to be somewhat
altered.

--

Gary S. Terhune
MS-MVP Shell/User
http://grystmill.org/articles/cleanboot.htm
http://grystmill.org/articles/security.htm

"PCR" wrote in message
...
That is all well & good, really. HOWEVER, after many months of
puzzlement, I found out the hard way that "/S" won't reach into a Hidden
or a System folder...

C:\dir c:\Autoexec.bat /s /a
Directory of C:\
AUTOEXEC BAT 557 02-24-05 1:17a AUTOEXEC.BAT
1 file(s) 557 bytes

Directory of C:\WINDOWS\TEMP
AUTOEXEC BAT 1,103 04-23-99 10:22p AUTOEXEC.BAT
1 file(s) 1,103 bytes

Total files listed:
2 file(s) 1,660 bytes

...BUT, I have one in...

C:\dir C:\system.sav\autoexec.bat
Directory of C:\system.sav
AUTOEXEC BAT 251 11-15-99 2:36p autoexec.bat
1 file(s) 251 bytes

..., which is attributed Hidden. (System also would do it.)...

C:\attrib C:\System.sav
H SYSTEM.SAV C:\system.sav

That is a sad "feature" of DOS, as I do have 11 directories attributed
System...

C:\dir /s /ads
...snip
Total files listed:
11 dir(s) 6,701.66 MB free

...And 34 directories that are Hidden...

C:\dir /s /adh
Total files listed:
34 dir(s) 6,701.66 MB free


--
Thanks or Good Luck,
There may be humor in this post, and,
Naturally, you will not sue,
should things get worse after this,
PCR

"Gary S. Terhune" wrote in message
...
| Use the DIR command in a Command prompt. Only drawback is that the
resulting
| file is not TAB separated and is not quickly, easily, imported into
Excel.
| For that purpose, you'd probably need a third-party app (don't think
it can
| be done with any basic Windows apps.)
|
| ***************************************
| Displays a list of files and subdirectories in a directory.
|
| DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
| [/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]
|
| [drive:][path][filename]
| Specifies drive, directory, and/or files to list.
| (Could be enhanced file specification or multiple
filespecs.)
| /P Pauses after each screenful of information.
| /W Uses wide list format.
| /A Displays files with specified attributes.
| attributes D Directories R Read-only files
| H Hidden files A Files ready for
archiving
| S System files - Prefix meaning not
| /O List by files in sorted order.
| sortorder N By name (alphabetic) S By size (smallest
first)
| E By extension (alphabetic) D By date & time
(earliest
| first)
| G Group directories first - Prefix to reverse
order
| A By Last Access Date (earliest first)
| /S Displays files in specified directory and all
subdirectories.
| /B Uses bare format (no heading information or summary).
| /L Uses lowercase.
| /V Verbose mode.
| /4 Displays year with 4 digits (ignored if /V also given).
|
| Switches may be preset in the DIRCMD environment variable. Override
| preset switches by prefixing any switch with - (hyphen)--for example,
/-W.
| ************************************************** *
|
| As you can see, this DIR command can be used to locate specific files.
To
| pipe the results to a text file, at the end of whatever command you
use add:
| "[path]find_results.txt" (without quotes) where [path] (without
brackets)
| is the directory you want to place the results file in, and
"find_results"
| is the name of the file.
|
| For best results, you should start in the root of the drive you are
| searching. To do this, use the CD (change directory) command:
| cd c:\
|
| For a different drive, just type "d:", "e:" (without quotes), etc.,
followed
| by enter. No need for the CD part.
|
| Examples:
| To locate all files named "*.doc", looking in the entire C:\ drive,
and save
| the results to C:\Find_DOC.txt
| dir *.doc /S C:\Find_DOC.txt
|
| To restrict the same search to C:\My Documents:
| dir "C:\my documents\*.doc" /S C:\Find_DOC.txt
|
| Note that whenever a path and/or filename includes any spaces, you
must
| enclose the entire path in "quotation marks".
|
| To do that same search looking *only* in My Documents, but not
sub-folders,
| leave out the /S switch.
| dir "C:\my documents\*.doc" C:\Find_DOC.txt
|
| For this purpose, the /W and /P switch are not useful. However, the
rest can
| come in handy.
|
| --
| Gary S. Terhune
| MS MVP Shell/User
| http://grystmill.com/articles/cleanboot.htm
| http://grystmill.com/articles/security.htm
|
| "Phil James" wrote in message
| ...
|
| If you use the "find" search system under "start," you get a list of
| files.
| How can that list be exported to an Excel spreadsheet? ...or
printed out?
|
| I have an IBM ThinkPad A20m 2820 running Windows SE.
|
| Phil James
|
|
|
|
|

"Gary S. Terhune" wrote in message
...
| Thanks for reminding me. Yes, the default is to *not* include files
with H
| and/or S attributes. Always has been thus with the DIR command. To get
all
| of them, you need to do one search w/o any attributes included, then
one for
| H-only, then one for S-only, and finally one for H+S.

I'm no perfect expert in DOS. Actually, though, I find "/a" alone will
display all files regardless of attributes. "DIR /s /a" goes into every
folder— EXCEPT for FOLDERS that are themselves attributed System or
Hidden. That's the insidious thing. If the H or S folder is the current
folder or is mentioned in the DIR, then it's H or S files will be
displayed, however. But it still won't go into H & S sub-folders to
that!

| These last three lists
| will necessarily include duplications. You'd want to merge the lists
to get
| those with *only* H, *only* S and H+S.

No. "/A" alone displays all attributes.

|But as noted (I think I noted it) the
| output is not really good for putting into Excel without first running
a
| script that would properly convert the results to a tab-delineated CSV
file.
| I've done similar things before, (specifically recall converting a
| collection of HTML database output records to a remerged CSV file.)
Might
| even have the scripts around here somewhere, only needing to be
somewhat
| altered.

I used to do similar long ago, but on IBM mainframe computers usiing
CMS.

| --
|
| Gary S. Terhune
| MS-MVP Shell/User
| http://grystmill.org/articles/cleanboot.htm
| http://grystmill.org/articles/security.htm
|
| "PCR" wrote in message
| ...
| That is all well & good, really. HOWEVER, after many months of
| puzzlement, I found out the hard way that "/S" won't reach into a
Hidden
| or a System folder...
|
| C:\dir c:\Autoexec.bat /s /a
| Directory of C:\
| AUTOEXEC BAT 557 02-24-05 1:17a AUTOEXEC.BAT
| 1 file(s) 557 bytes
|
| Directory of C:\WINDOWS\TEMP
| AUTOEXEC BAT 1,103 04-23-99 10:22p AUTOEXEC.BAT
| 1 file(s) 1,103 bytes
|
| Total files listed:
| 2 file(s) 1,660 bytes
|
| ...BUT, I have one in...
|
| C:\dir C:\system.sav\autoexec.bat
| Directory of C:\system.sav
| AUTOEXEC BAT 251 11-15-99 2:36p autoexec.bat
| 1 file(s) 251 bytes
|
| ..., which is attributed Hidden. (System also would do it.)...
|
| C:\attrib C:\System.sav
| H SYSTEM.SAV C:\system.sav
|
| That is a sad "feature" of DOS, as I do have 11 directories
attributed
| System...
|
| C:\dir /s /ads
| ...snip
| Total files listed:
| 11 dir(s) 6,701.66 MB free
|
| ...And 34 directories that are Hidden...
|
| C:\dir /s /adh
| Total files listed:
| 34 dir(s) 6,701.66 MB free
|
|
| --
| Thanks or Good Luck,
| There may be humor in this post, and,
| Naturally, you will not sue,
| should things get worse after this,
| PCR
|
| "Gary S. Terhune" wrote in message
| ...
| | Use the DIR command in a Command prompt. Only drawback is that the
| resulting
| | file is not TAB separated and is not quickly, easily, imported
into
| Excel.
| | For that purpose, you'd probably need a third-party app (don't
think
| it can
| | be done with any basic Windows apps.)
| |
| | ***************************************
| | Displays a list of files and subdirectories in a directory.
| |
| | DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
| | [/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]
| |
| | [drive:][path][filename]
| | Specifies drive, directory, and/or files to list.
| | (Could be enhanced file specification or multiple
| filespecs.)
| | /P Pauses after each screenful of information.
| | /W Uses wide list format.
| | /A Displays files with specified attributes.
| | attributes D Directories R Read-only files
| | H Hidden files A Files ready for
| archiving
| | S System files - Prefix meaning not
| | /O List by files in sorted order.
| | sortorder N By name (alphabetic) S By size (smallest
| first)
| | E By extension (alphabetic) D By date & time
| (earliest
| | first)
| | G Group directories first - Prefix to reverse
| order
| | A By Last Access Date (earliest first)
| | /S Displays files in specified directory and all
| subdirectories.
| | /B Uses bare format (no heading information or
summary).
| | /L Uses lowercase.
| | /V Verbose mode.
| | /4 Displays year with 4 digits (ignored if /V also
given).
| |
| | Switches may be preset in the DIRCMD environment variable.
Override
| | preset switches by prefixing any switch with - (hyphen)--for
example,
| /-W.
| | ************************************************** *
| |
| | As you can see, this DIR command can be used to locate specific
files.
| To
| | pipe the results to a text file, at the end of whatever command
you
| use add:
| | "[path]find_results.txt" (without quotes) where [path] (without
| brackets)
| | is the directory you want to place the results file in, and
| "find_results"
| | is the name of the file.
| |
| | For best results, you should start in the root of the drive you
are
| | searching. To do this, use the CD (change directory) command:
| | cd c:\
| |
| | For a different drive, just type "d:", "e:" (without quotes),
etc.,
| followed
| | by enter. No need for the CD part.
| |
| | Examples:
| | To locate all files named "*.doc", looking in the entire C:\
drive,
| and save
| | the results to C:\Find_DOC.txt
| | dir *.doc /S C:\Find_DOC.txt
| |
| | To restrict the same search to C:\My Documents:
| | dir "C:\my documents\*.doc" /S C:\Find_DOC.txt
| |
| | Note that whenever a path and/or filename includes any spaces, you
| must
| | enclose the entire path in "quotation marks".
| |
| | To do that same search looking *only* in My Documents, but not
| sub-folders,
| | leave out the /S switch.
| | dir "C:\my documents\*.doc" C:\Find_DOC.txt
| |
| | For this purpose, the /W and /P switch are not useful. However,
the
| rest can
| | come in handy.
| |
| | --
| | Gary S. Terhune
| | MS MVP Shell/User
| | http://grystmill.com/articles/cleanboot.htm
| | http://grystmill.com/articles/security.htm
| |
| | "Phil James" wrote in message
| | ...
| |
| | If you use the "find" search system under "start," you get a
list of
| | files.
| | How can that list be exported to an Excel spreadsheet? ...or
| printed out?
| |
| | I have an IBM ThinkPad A20m 2820 running Windows SE.
| |
| | Phil James
| |
| |
| |
| |
| |
|
|
|
|
|

That will not do what's asked, Don. All you get is a shortcut thingy that
repeats the search, not a results file like OP wants.

--

Gary S. Terhune
MS-MVP Shell/User
http://grystmill.org/articles/cleanboot.htm
http://grystmill.org/articles/security.htm


"Don Phillipson" wrote in message
...
"Phil James" wrote in message
...

If you use the "find" search system under "start," you get a list of
files.
How can that list be exported to an Excel spreadsheet? ...or printed
out?

Make use of
/ Options / Save Results
(and provide a TXT or all-ASCII filename.)

Don Phillipson
Carlsbad Springs
(Ottawa, Canada)

Another cool trick. Learn something every day. So the /A switch includes all
attributes, which effectively includes all files. But you can't get into
Hidden+System subfolders? Something to remember.

Oh well, it's a klutzy way to do what the OP wants, anyway. I think a
third-party utility is called for. There's an interesting freeware offering
he
http://www.jam-software.com/freeware/index.shtml

Near the bottom of the page, FileList V1.5
http://www.jam-software.com/freeware/FileList.zip

"FileList is a command line utility that produces a list of files of the
given path in the CSV format, which can be imported in a spreadsheet or
database. The list includes the file name, the size, the path, the file
extension, the owner of the file (only Windows NT/2000/XP) as well as the
last access and change date and the creation date of the file. Optionally
the author of MS Office documents can be displayed."

--

Gary S. Terhune
MS-MVP Shell/User
http://grystmill.org/articles/cleanboot.htm
http://grystmill.org/articles/security.htm


"PCR" wrote in message
...
"Gary S. Terhune" wrote in message
...
| Thanks for reminding me. Yes, the default is to *not* include files
with H
| and/or S attributes. Always has been thus with the DIR command. To get
all
| of them, you need to do one search w/o any attributes included, then
one for
| H-only, then one for S-only, and finally one for H+S.

I'm no perfect expert in DOS. Actually, though, I find "/a" alone will
display all files regardless of attributes. "DIR /s /a" goes into every
folder- EXCEPT for FOLDERS that are themselves attributed System or
Hidden. That's the insidious thing. If the H or S folder is the current
folder or is mentioned in the DIR, then it's H or S files will be
displayed, however. But it still won't go into H & S sub-folders to
that!

| These last three lists
| will necessarily include duplications. You'd want to merge the lists
to get
| those with *only* H, *only* S and H+S.

No. "/A" alone displays all attributes.

|But as noted (I think I noted it) the
| output is not really good for putting into Excel without first running
a
| script that would properly convert the results to a tab-delineated CSV
file.
| I've done similar things before, (specifically recall converting a
| collection of HTML database output records to a remerged CSV file.)
Might
| even have the scripts around here somewhere, only needing to be
somewhat
| altered.

I used to do similar long ago, but on IBM mainframe computers usiing
CMS.

| --
|
| Gary S. Terhune
| MS-MVP Shell/User
| http://grystmill.org/articles/cleanboot.htm
| http://grystmill.org/articles/security.htm
|
| "PCR" wrote in message
| ...
| That is all well & good, really. HOWEVER, after many months of
| puzzlement, I found out the hard way that "/S" won't reach into a
Hidden
| or a System folder...
|
| C:\dir c:\Autoexec.bat /s /a
| Directory of C:\
| AUTOEXEC BAT 557 02-24-05 1:17a AUTOEXEC.BAT
| 1 file(s) 557 bytes
|
| Directory of C:\WINDOWS\TEMP
| AUTOEXEC BAT 1,103 04-23-99 10:22p AUTOEXEC.BAT
| 1 file(s) 1,103 bytes
|
| Total files listed:
| 2 file(s) 1,660 bytes
|
| ...BUT, I have one in...
|
| C:\dir C:\system.sav\autoexec.bat
| Directory of C:\system.sav
| AUTOEXEC BAT 251 11-15-99 2:36p autoexec.bat
| 1 file(s) 251 bytes
|
| ..., which is attributed Hidden. (System also would do it.)...
|
| C:\attrib C:\System.sav
| H SYSTEM.SAV C:\system.sav
|
| That is a sad "feature" of DOS, as I do have 11 directories
attributed
| System...
|
| C:\dir /s /ads
| ...snip
| Total files listed:
| 11 dir(s) 6,701.66 MB free
|
| ...And 34 directories that are Hidden...
|
| C:\dir /s /adh
| Total files listed:
| 34 dir(s) 6,701.66 MB free
|
|
| --
| Thanks or Good Luck,
| There may be humor in this post, and,
| Naturally, you will not sue,
| should things get worse after this,
| PCR
|
| "Gary S. Terhune" wrote in message
| ...
| | Use the DIR command in a Command prompt. Only drawback is that the
| resulting
| | file is not TAB separated and is not quickly, easily, imported
into
| Excel.
| | For that purpose, you'd probably need a third-party app (don't
think
| it can
| | be done with any basic Windows apps.)
| |
| | ***************************************
| | Displays a list of files and subdirectories in a directory.
| |
| | DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
| | [/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]
| |
| | [drive:][path][filename]
| | Specifies drive, directory, and/or files to list.
| | (Could be enhanced file specification or multiple
| filespecs.)
| | /P Pauses after each screenful of information.
| | /W Uses wide list format.
| | /A Displays files with specified attributes.
| | attributes D Directories R Read-only files
| | H Hidden files A Files ready for
| archiving
| | S System files - Prefix meaning not
| | /O List by files in sorted order.
| | sortorder N By name (alphabetic) S By size (smallest
| first)
| | E By extension (alphabetic) D By date & time
| (earliest
| | first)
| | G Group directories first - Prefix to reverse
| order
| | A By Last Access Date (earliest first)
| | /S Displays files in specified directory and all
| subdirectories.
| | /B Uses bare format (no heading information or
summary).
| | /L Uses lowercase.
| | /V Verbose mode.
| | /4 Displays year with 4 digits (ignored if /V also
given).
| |
| | Switches may be preset in the DIRCMD environment variable.
Override
| | preset switches by prefixing any switch with - (hyphen)--for
example,
| /-W.
| | ************************************************** *
| |
| | As you can see, this DIR command can be used to locate specific
files.
| To
| | pipe the results to a text file, at the end of whatever command
you
| use add:
| | "[path]find_results.txt" (without quotes) where [path] (without
| brackets)
| | is the directory you want to place the results file in, and
| "find_results"
| | is the name of the file.
| |
| | For best results, you should start in the root of the drive you
are
| | searching. To do this, use the CD (change directory) command:
| | cd c:\
| |
| | For a different drive, just type "d:", "e:" (without quotes),
etc.,
| followed
| | by enter. No need for the CD part.
| |
| | Examples:
| | To locate all files named "*.doc", looking in the entire C:\
drive,
| and save
| | the results to C:\Find_DOC.txt
| | dir *.doc /S C:\Find_DOC.txt
| |
| | To restrict the same search to C:\My Documents:
| | dir "C:\my documents\*.doc" /S C:\Find_DOC.txt
| |
| | Note that whenever a path and/or filename includes any spaces, you
| must
| | enclose the entire path in "quotation marks".
| |
| | To do that same search looking *only* in My Documents, but not
| sub-folders,
| | leave out the /S switch.
| | dir "C:\my documents\*.doc" C:\Find_DOC.txt
| |
| | For this purpose, the /W and /P switch are not useful. However,
the
| rest can
| | come in handy.
| |
| | --
| | Gary S. Terhune
| | MS MVP Shell/User
| | http://grystmill.com/articles/cleanboot.htm
| | http://grystmill.com/articles/security.htm
| |
| | "Phil James" wrote in message
| | ...
| |
| | If you use the "find" search system under "start," you get a
list of
| | files.
| | How can that list be exported to an Excel spreadsheet? ...or
| printed out?
| |
| | I have an IBM ThinkPad A20m 2820 running Windows SE.
| |
| | Phil James
| |
| |
| |
| |
| |
|
|
|
|
|

"Gary S. Terhune" wrote in message
...
| Another cool trick. Learn something every day. So the /A switch
includes all
| attributes, which effectively includes all files. But you can't get
into
| Hidden+System subfolders? Something to remember.

That is correct. /A =all attributes. And /S, even with /a, will not
rnter an H or S folder, not using the DIR command, anyhow.

| Oh well, it's a klutzy way to do what the OP wants, anyway. I think a
| third-party utility is called for. There's an interesting freeware
offering
| he
| http://www.jam-software.com/freeware/index.shtml
|
| Near the bottom of the page, FileList V1.5
| http://www.jam-software.com/freeware/FileList.zip
|
| "FileList is a command line utility that produces a list of files of
the
| given path in the CSV format, which can be imported in a spreadsheet
or
| database. The list includes the file name, the size, the path, the
file
| extension, the owner of the file (only Windows NT/2000/XP) as well as
the
| last access and change date and the creation date of the file.
Optionally
| the author of MS Office documents can be displayed."

Yea, that's a better approach. Alternatively, familiarize yourself with
your H & S folders &/or decide you don't care what's in those, anyhow.

| --
|
| Gary S. Terhune
| MS-MVP Shell/User
| http://grystmill.org/articles/cleanboot.htm
| http://grystmill.org/articles/security.htm
|
|
| "PCR" wrote in message
| ...
| "Gary S. Terhune" wrote in message
| ...
| | Thanks for reminding me. Yes, the default is to *not* include
files
| with H
| | and/or S attributes. Always has been thus with the DIR command. To
get
| all
| | of them, you need to do one search w/o any attributes included,
then
| one for
| | H-only, then one for S-only, and finally one for H+S.
|
| I'm no perfect expert in DOS. Actually, though, I find "/a" alone
will
| display all files regardless of attributes. "DIR /s /a" goes into
every
| folder- EXCEPT for FOLDERS that are themselves attributed System or
| Hidden. That's the insidious thing. If the H or S folder is the
current
| folder or is mentioned in the DIR, then it's H or S files will be

"Its", I guess I meant— not "it's"! OK, bye.

| displayed, however. But it still won't go into H & S sub-folders to
| that!
|
| | These last three lists
| | will necessarily include duplications. You'd want to merge the
lists
| to get
| | those with *only* H, *only* S and H+S.
|
| No. "/A" alone displays all attributes.
|
| |But as noted (I think I noted it) the
| | output is not really good for putting into Excel without first
running
| a
| | script that would properly convert the results to a tab-delineated
CSV
| file.
| | I've done similar things before, (specifically recall converting a
| | collection of HTML database output records to a remerged CSV
file.)
| Might
| | even have the scripts around here somewhere, only needing to be
| somewhat
| | altered.
|
| I used to do similar long ago, but on IBM mainframe computers usiing
| CMS.
|
| | --
| |
| | Gary S. Terhune
| | MS-MVP Shell/User
| | http://grystmill.org/articles/cleanboot.htm
| | http://grystmill.org/articles/security.htm
| |
| | "PCR" wrote in message
| | ...
| | That is all well & good, really. HOWEVER, after many months of
| | puzzlement, I found out the hard way that "/S" won't reach into
a
| Hidden
| | or a System folder...
| |
| | C:\dir c:\Autoexec.bat /s /a
| | Directory of C:\
| | AUTOEXEC BAT 557 02-24-05 1:17a AUTOEXEC.BAT
| | 1 file(s) 557 bytes
| |
| | Directory of C:\WINDOWS\TEMP
| | AUTOEXEC BAT 1,103 04-23-99 10:22p AUTOEXEC.BAT
| | 1 file(s) 1,103 bytes
| |
| | Total files listed:
| | 2 file(s) 1,660 bytes
| |
| | ...BUT, I have one in...
| |
| | C:\dir C:\system.sav\autoexec.bat
| | Directory of C:\system.sav
| | AUTOEXEC BAT 251 11-15-99 2:36p autoexec.bat
| | 1 file(s) 251 bytes
| |
| | ..., which is attributed Hidden. (System also would do it.)...
| |
| | C:\attrib C:\System.sav
| | H SYSTEM.SAV C:\system.sav
| |
| | That is a sad "feature" of DOS, as I do have 11 directories
| attributed
| | System...
| |
| | C:\dir /s /ads
| | ...snip
| | Total files listed:
| | 11 dir(s) 6,701.66 MB free
| |
| | ...And 34 directories that are Hidden...
| |
| | C:\dir /s /adh
| | Total files listed:
| | 34 dir(s) 6,701.66 MB free
| |
| |
| | --
| | Thanks or Good Luck,
| | There may be humor in this post, and,
| | Naturally, you will not sue,
| | should things get worse after this,
| | PCR
| |
| | "Gary S. Terhune" wrote in message
| | ...
| | | Use the DIR command in a Command prompt. Only drawback is that
the
| | resulting
| | | file is not TAB separated and is not quickly, easily, imported
| into
| | Excel.
| | | For that purpose, you'd probably need a third-party app (don't
| think
| | it can
| | | be done with any basic Windows apps.)
| | |
| | | ***************************************
| | | Displays a list of files and subdirectories in a directory.
| | |
| | | DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
| | | [/O[[:]sortorder]] [/S] [/b] [/L] [/V] [/4]
| | |
| | | [drive:][path][filename]
| | | Specifies drive, directory, and/or files to
list.
| | | (Could be enhanced file specification or
multiple
| | filespecs.)
| | | /P Pauses after each screenful of information.
| | | /W Uses wide list format.
| | | /A Displays files with specified attributes.
| | | attributes D Directories R Read-only
files
| | | H Hidden files A Files ready
for
| | archiving
| | | S System files - Prefix meaning
not
| | | /O List by files in sorted order.
| | | sortorder N By name (alphabetic) S By size
(smallest
| | first)
| | | E By extension (alphabetic) D By date & time
| | (earliest
| | | first)
| | | G Group directories first - Prefix to
reverse
| | order
| | | A By Last Access Date (earliest first)
| | | /S Displays files in specified directory and all
| | subdirectories.
| | | /B Uses bare format (no heading information or
| summary).
| | | /L Uses lowercase.
| | | /V Verbose mode.
| | | /4 Displays year with 4 digits (ignored if /V also
| given).
| | |
| | | Switches may be preset in the DIRCMD environment variable.
| Override
| | | preset switches by prefixing any switch with - (hyphen)--for
| example,
| | /-W.
| | | ************************************************** *
| | |
| | | As you can see, this DIR command can be used to locate
specific
| files.
| | To
| | | pipe the results to a text file, at the end of whatever
command
| you
| | use add:
| | | "[path]find_results.txt" (without quotes) where [path]
(without
| | brackets)
| | | is the directory you want to place the results file in, and
| | "find_results"
| | | is the name of the file.
| | |
| | | For best results, you should start in the root of the drive
you
| are
| | | searching. To do this, use the CD (change directory) command:
| | | cd c:\
| | |
| | | For a different drive, just type "d:", "e:" (without quotes),
| etc.,
| | followed
| | | by enter. No need for the CD part.
| | |
| | | Examples:
| | | To locate all files named "*.doc", looking in the entire C:\
| drive,
| | and save
| | | the results to C:\Find_DOC.txt
| | | dir *.doc /S C:\Find_DOC.txt
| | |
| | | To restrict the same search to C:\My Documents:
| | | dir "C:\my documents\*.doc" /S C:\Find_DOC.txt
| | |
| | | Note that whenever a path and/or filename includes any spaces,
you
| | must
| | | enclose the entire path in "quotation marks".
| | |
| | | To do that same search looking *only* in My Documents, but not
| | sub-folders,
| | | leave out the /S switch.
| | | dir "C:\my documents\*.doc" C:\Find_DOC.txt
| | |
| | | For this purpose, the /W and /P switch are not useful.
However,
| the
| | rest can
| | | come in handy.
| | |
| | | --
| | | Gary S. Terhune
| | | MS MVP Shell/User
| | | http://grystmill.com/articles/cleanboot.htm
| | | http://grystmill.com/articles/security.htm
| | |
| | | "Phil James" wrote in message
| | | ...
| | |
| | | If you use the "find" search system under "start," you get a
| list of
| | | files.
| | | How can that list be exported to an Excel spreadsheet?
....or
| | printed out?
| | |
| | | I have an IBM ThinkPad A20m 2820 running Windows SE.
| | |
| | | Phil James
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
| |
|
|
|
|

On Mon, 6 Nov 2006 17:10:30 -0800, "Gary S. Terhune"
put finger to keyboard and composed:

That will not do what's asked, Don. All you get is a shortcut thingy that
repeats the search, not a results file like OP wants.

Your answer is a bit ambiguous. The desktop shortcut can point to a
..fnd file that contains either the *parameters* for the search or the
*results* of the last search. You're right, however, in that the
format of the results file is not what the OP is looking for.


Gary S. Terhune
MS-MVP Shell/User
http://grystmill.org/articles/cleanboot.htm
http://grystmill.org/articles/security.htm


"Don Phillipson" wrote in message
...
"Phil James" wrote in message
...

If you use the "find" search system under "start," you get a list of
files.
How can that list be exported to an Excel spreadsheet? ...or printed
out?

Make use of
/ Options / Save Results
(and provide a TXT or all-ASCII filename.)

Don Phillipson
Carlsbad Springs
(Ottawa, Canada)

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.