WikiWirral Online with you since 2003, fantastic.
Forum Stats
12452 Members
65 Forums
73749 Topics
996902 Posts
68 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
75 registered (8HBob, 16 invisible), 1379 Guests and 246 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Games for children 1000
Fitting bathroom lights need help 356
Travelling Bus and Train Which Tickets? 307
Charity fishing match 288
Anyone read this ? 271
Replacement Key Fob casing 269
Taltalk Broadband Dying 262
Submarine Disaster 240
Bath Lifts 188
Are there any doctors or nurses on here. 127
New General Forums
Brexit bill
by casper
07:33 PM
Telephone Caller Alert - they are NOT BT BROADBAND
by Laraine
17th Nov 2017 6:04pm
Are you a Mathematician ?
by granny
15th Nov 2017 8:59am
Poor Bruce
by diggingdeeper
15th Nov 2017 1:15am
New Wirral History
Downloadable oldwirral pdfs
by derekdwc
9th Oct 2017 12:26pm
Forum Tips
Photo Gallery Forums
clipper yachts arriving for round the world race
Azamara,silouette and balmoral this mornig
Topic Replies
Great Mystery Of Our Time
by Spellbinder
Fitting bathroom lights need help
by diggingdeeper
Submarine Disaster
by diggingdeeper
04:16 PM
Extending dining table with six chairs
by Salmon
03:50 PM
What is your Daily Exercise ?
by granny
10:11 PM
Vaping set
by paul110180
01:45 PM
Charity fishing match
by paul110180
01:43 PM
Charity fishing match
by paul110180
01:32 PM
Games for children
by venice
01:58 AM
November
M Tu W Th F Sa Su
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30
Recent Posts : What's On ?
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
bonfire night
by snowhite
3rd Nov 2017 5:40pm
Topic Options
Rate This Topic
#770964 - 22nd Feb 2013 2:46pm finding files to create a list of them
derekdwc Offline


Forum Veteran

Registered: 13th Oct 2008
Posts: 5024
Loc: Birkenhead
When using xp if I go to start then search if I type in .jpeg it comes up with all the jpegs or whatever file extension I put in.
What I'd like would be a program that would do the same but would enable me to make an excel list of them.
Got loads of mobi,jpeg,txt and pdf to sort out in various folders.
Been at it for a couple of days trying to sort

Could someone put the run-cmd lineon here in simple terms where to put the folder and file type if that works
Thanks


Edited by derekdwc (22nd Feb 2013 2:49pm)

Top
Google Ads
#771011 - 22nd Feb 2013 5:37pm Re: finding files to create a list of them [Re: derekdwc]
Neilj Offline
Beginner

Registered: 9th Jan 2009
Posts: 7
Loc: Wallasey
Choose Start/Programs/Accessories/notepad to load a version of notepad

In notepad type in the following line of text......

dir c:\*.jp* /s > c:\users\yourwindowsname\desktop\output.txt

In the above replace "yourwindowsname" with whatever your windows login name is.
then click File / Save and save the file on your desktop however you MUST call the file so that
it has .bat at the end e.g. call it myprogram.bat - do not call it myprogram.txt otherwise it will not work.
It is important that the filename ends .bat so that it knows it is a batch program

You can run this 'batch program - c:\myprogram.bat' by double clicking on it in windows explorer

You should then see a file called output.txt appear on your desktop when it has finished showing all .jpg or .jpeg files

You can use same code and replace *.jp* with *.txt for text files *.xls* for excel files, *.doc* for word files etc. or *.* file all files. The /s means look in all sub directories.

Top
#771013 - 22nd Feb 2013 5:40pm Re: finding files to create a list of them [Re: derekdwc]
Rambo Offline
Addict

Registered: 4th Jul 2012
Posts: 230
Loc: Usually at work!
Try this free program to do it for you;

http://www.infonautics.ch/directorylistprint/

Top
#771017 - 22nd Feb 2013 5:41pm Re: finding files to create a list of them [Re: derekdwc]
Absinthian Offline
Beginner

Registered: 14th Mar 2012
Posts: 8
Loc: Greasby
From the command prompt, use this:

DIR <StartDir> *.jpg,*.pdf,*.ext /b /s >files.csv

Where <StartDir> is the 'root' of where you want to start the search from (eg C:\ for start from C: drive root.

You can have more file types to search than those three, obviously! Just change/add what you want to search for.

The list of files will be written into the file 'files.csv'. This will be able to be opened directly in Excel.

There's plenty of other switches that DIR can use simply enter DIR /? to see them.

Top
#771035 - 22nd Feb 2013 6:59pm Re: finding files to create a list of them [Re: derekdwc]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21085
Loc: Wirral
Derek if your stuck,I can help you Doing the above.
It's easy when you have been shown how.

Batch programs if not done correctly can do a lot of damage if you change the command. In this case DIR is the command.

If your on the wikiwalk on Sunday I can give you some pointers / help.
_________________________
My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile

Top
#772605 - 27th Feb 2013 5:43pm Re: finding files to create a list of them [Re: Rambo]
derekdwc Offline


Forum Veteran

Registered: 13th Oct 2008
Posts: 5024
Loc: Birkenhead
Originally Posted By: Rambo
Try this free program to do it for you;

http://www.infonautics.ch/directorylistprint/


THANKS
Bought the pro version. Does what I wanted

Top

Moderator:  Mark 
Random Wirral Images

Click to View Topic.
Newest Topics
Great Mystery Of Our Time
by Spellbinder
02:19 PM
Submarine Disaster
by diggingdeeper
05:46 PM
Fitting bathroom lights need help
by yr20405
17th Nov 2017 11:29pm
Charity fishing match
by paul110180
17th Nov 2017 9:29pm
Games for children
by granny
17th Nov 2017 1:35am
For Sale & Free
Extending dining table with six chairs
by kazaroo
04:46 PM
Water Dispenser Cold Cool Machine Cooler
by markyport
19th Nov 2017 4:45pm
where to get cheap carpet
by mickturner
17th Nov 2017 4:24pm
White radiator single panel 1400 x 600 - good cond
by gerrymoore
16th Nov 2017 9:16am
Samsung Galaxy S7 Titanium Silver + Extras
by j_demo
15th Nov 2017 7:29pm
Featured Member
Registered: 28th Nov 2009
Posts: 140
Newest Members
wagonwheel82, Norfolk, monadrexx, Dipper, DarioLo
12452 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Fitting bathroom lights need help
by yr20405
17th Nov 2017 11:29pm
Games for children
by granny
17th Nov 2017 1:35am
Bath Lifts
by locomotive
16th Nov 2017 6:22pm
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
Travelling Bus and Train Which Tickets?
by fish5133
15th Nov 2017 5:31pm
News : New Topics
Great Mystery Of Our Time
by Spellbinder
02:19 PM
Submarine Disaster
by diggingdeeper
05:46 PM
Anyone read this ?
by venice
16th Nov 2017 3:22pm
Is this crime against humanity
by granny
13th Nov 2017 4:04pm
Wedding for Cancer Research !
by Katemargaret
11th Nov 2017 10:38pm
New Enthusiast Forums
Charity fishing match
by paul110180
17th Nov 2017 9:29pm
Are there any doctors or nurses on here.
by granny
16th Nov 2017 11:52pm
Taltalk Broadband Dying
by diggingdeeper
15th Nov 2017 3:40am
Replacement Key Fob casing
by fish5133
14th Nov 2017 7:45pm
Insecure sites.
by venice
13th Nov 2017 3:54pm
(Views 24hrs)Trending Newest Topics
Submarine Disaster 240
Great Mystery Of Our Time 105
Brexit bill 34
Wirral Sunrise Sunset
Sunrise Tue 7:50am
Sunset Tue 4:06pm
Local Time Tue 5:35pm
WikiWirral Can . . . .