WikiWirral Share a Little Learn a Lot about your Wirral
Forum Statistics
Forums65
Topics76,352
Posts1,033,281
Members14,560
Most Online16,551
Feb 2nd, 2024
Who's Online Now
8 members (3 invisible), 8,693 guests, and 424 robots.
Key: Admin, Global Mod, Mod
Top Posters
sunnyside 45,164
MattLFC 22,315
Mark 21,269
granny 17,788
_Ste_ 16,345
Newest Members
Kalena1962, rattus, Lisrush, Emotecreative, ArranGirl13
14,560 Registered Users
New General Forums
New Wirral History
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
D.I.Y. / Building Shop
by mharford91 - 3rd Mar 2024 8:53pm
1970's Murder in Central Park, Wallasey
by cutespam - 4th Aug 2018 10:28am
Old Hall in Higher Bebington
by Rhoobarb - 25th May 2010 5:55pm
Oleo Works
by Ducko - 14th May 2008 3:09pm
Top Posters(30 Days)
granny 14
casper 13
bri445 4
Topic Replies
What song are you listening to?
by diggingdeeper - 28th Mar 2024 6:06pm
Facial recognition coming in supermarkets?
by diggingdeeper - 27th Mar 2024 3:50pm
Bolts at Bebington Road
by diggingdeeper - 27th Mar 2024 2:33am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Tall Brick Chimneys
by diggingdeeper - 26th Mar 2024 5:43pm
Lost river (Well, brook really)
by diggingdeeper - 26th Mar 2024 3:09am
Old Hall in Higher Bebington
by diggingdeeper - 24th Mar 2024 5:58pm
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
March
M T W T F S S
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 31
Top Likes Received (30 Days)
cools 1
Kylix 1
Top Likes Received
bert1 14
Mark 4
granny 3
casper 3
Previous Thread
Next Thread
Print Thread
Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
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

Last edited by derekdwc; 22nd Feb 2013 2:49pm.
Google Ads
Joined: Jan 2009
Posts: 10
Newbeee
Offline
Newbeee
Joined: Jan 2009
Posts: 10
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.

Joined: Jul 2012
Posts: 230
Addict
Offline
Addict
Joined: Jul 2012
Posts: 230
Try this free program to do it for you;

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


Joined: Mar 2012
Posts: 8
Beginner
Offline
Beginner
Joined: Mar 2012
Posts: 8
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.

Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
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.

Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
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


Moderated by  Mark 

Link Copied to Clipboard
Random Wirral Images

Click to View Topic.
Newest Topics
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
For Sale & Free
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
This is Elvis
by GingerTom - 17th Mar 2024 2:37pm
Member Spotlight
KevinFinity
KevinFinity
Wirral
Posts: 2,354
Joined: April 2009
Today's Birthdays
There are no members with birthdays on this day.
New Wirral Info
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Get your Money Tree ready
by keef666 - 22nd Mar 2023 12:27pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM - 7th Aug 2020 7:59pm
News : New Topics
Gaza
by diggingdeeper - 29th Oct 2023 9:28am
Lost river (Well, brook really)
by Excoriator - 10th Sep 2019 8:50am
New Enthusiast Forums
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Xbox
by TudorBlue - 3rd Mar 2024 8:48pm
Wiper mechanism needed
by Peter0787 - 20th Feb 2024 4:07pm
What song are you listening to?
by - 24th Jun 2007 9:06am
Popular Topics(Views)
5,069,784 WIKI WALK CHAT
4,013,883 Spotted!
Powered by UBB.threads™ PHP Forum Software 7.7.5