WikiWirral values you and your opinion.
Forum Stats
12254 Members
65 Forums
72900 Topics
982774 Posts
55 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
83 registered (alan128, 15 invisible), 1890 Guests and 336 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Boom : New Ferry Explosion 2434
Incident at Westminster 1682
Offset number plates 551
Death at Leasowe Train Station 419
Huge Gas Explosion in New Ferry Sat 25/03/17 401
What does this all mean? 272
Planet Earth Tonight 266
Has Talktalk been hacked yet again? 237
Snowhite's Bird Rescue 202
Reclaimed floorboards needed. 195
New General Forums
hi
by norma67
26th Mar 2017 7:42pm
Clocks go Forward
by Mark
25th Mar 2017 3:01pm
Mannequin Challenge AKA MRI Scan
by fish5133
24th Mar 2017 11:20am
Surely the most honest add.....
by buddy
20th Mar 2017 5:43pm
New Wirral History
William Bernard's building, Birkenhead
by yoller
20th Mar 2017 4:27pm
1882 Plan of the borough of Birkenhead and Wards
by Dave_Wood
19th Mar 2017 11:57am
New Brighton Coop
by Mike_White
9th Mar 2017 12:48pm
Tranmere High School for Girls 1882 Chesnut Grove
by sarah708
6th Mar 2017 8:23pm
Whetstone Lane, Birkenhead
by MoretonExpat
6th Mar 2017 8:04am
Forum Tips
Photo Gallery Forums
Birkenhead Transport Museum 24th Feb 2017
fireworks on the Mersey last night
Topic Replies
Will It Work For You
by casper
hi
by Dilly
11:36 PM
'March' Photo Competition.
by snowshoes
10:58 PM
Boom : New Ferry Explosion
by fish5133
08:27 PM
It's Broken : Forum Update
by Mark
08:13 PM
Prescriptions
by diggingdeeper
06:55 PM
Death at Leasowe Train Station
by fish5133
27th Mar 2017 11:12pm
What song are you listening to?
by Vanmanone
27th Mar 2017 3:50pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by venice
27th Mar 2017 1:18pm
March
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 31
Recent Posts : What's On ?
Planet Earth Tonight
by Excoriator
26th Mar 2017 10:31am
Lee and Cragg Quarries - Bacup
by Mark
23rd Mar 2017 7:43am
Topic Options
Rate This Topic
#770964 - 22nd Feb 2013 2:46pm finding files to create a list of them
derekdwc Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 4983
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
Digital Wirral : Advertising
Click me for more Information......

* * * vipstudios.co.uk - Photographic Studios * * *
Now Advertise with WikiWirral.
WikiWirral stats 35,000 Page Views a Day +500 Search Engines.. Click Me
#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: 6
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: 21031
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 Online   content


Forum Veteran

Registered: 13th Oct 2008
Posts: 4983
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
Will It Work For You
by granny
08:26 AM
Death at Leasowe Train Station
by Mark
27th Mar 2017 10:02pm
KEYS found
by rocks
26th Mar 2017 11:48pm
hi
by norma67
26th Mar 2017 7:42pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by Dogwalker59
26th Mar 2017 10:36am
For Sale & Free
boxed 10 inch tablet for sale
by stumpyduck
26th Mar 2017 7:12pm
various fly reels and boxes of fly's
by brady
25th Mar 2017 10:48am
Challenge extreme angle grinder used once
by brady
25th Mar 2017 10:43am
White Hyundai I30, 2011 plate For sale, 1.4 petrol
by goodoldphil
24th Mar 2017 6:24pm
I am having a clear out!
by TheComputerLab
24th Mar 2017 4:01pm
Featured Member
Registered: 21st Jan 2010
Posts: 837
Newest Members
BoilerEngineer, flipmodefly, Noize, cartoonhead, shelleyc1990
12254 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Planet Earth Tonight
by granny
25th Mar 2017 11:50am
Reclaimed floorboards needed.
by Gold_Moon
25th Mar 2017 10:45am
Has Talktalk been hacked yet again?
by Habdab
24th Mar 2017 10:25am
What does this all mean?
by venice
22nd Mar 2017 12:20pm
black contiboard locally?
by fish5133
21st Mar 2017 9:30pm
News : New Topics
Death at Leasowe Train Station
by Mark
27th Mar 2017 10:02pm
KEYS found
by rocks
26th Mar 2017 11:48pm
Another Terrorist Attack ? -London Islington
by fish5133
26th Mar 2017 3:03pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by Dogwalker59
26th Mar 2017 10:36am
Boom : New Ferry Explosion
by diggingdeeper
25th Mar 2017 9:39pm
New Enthusiast Forums
Will It Work For You
by granny
08:26 AM
Snowhite's Bird Rescue
by diggingdeeper
26th Mar 2017 2:44am
Offset number plates
by venice
23rd Mar 2017 1:24am
File too large
by Dilly
20th Mar 2017 10:41am
ford focus 1.6 t reg rattling
by Little_B
19th Mar 2017 11:02pm
(Views 24hrs)Trending Newest Topics
Will It Work For You 12
Wirral Sunrise Sunset
Sunrise Wed 6:50am
Sunset Wed 7:42pm
Local Time Wed 10:14am
WikiWirral Can . . . .