WikiWirral Share a Little Learn a Lot about your Wirral
Forum Stats
12221 Members
65 Forums
72731 Topics
980285 Posts
43 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
95 registered (8HBob, 15 invisible), 1471 Guests and 195 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Thousands raised for children of cancer couple. 461
On-street parking charges dropped 399
Ceiling needs smoothing 344
Patio work 232
TS Indefatigable 227
Hezballah 217
Sea Shepherd 203
vet fees 115
Re sizing 79
Seeking old pictures of Egerton Street area, Birkenhead 61
New General Forums
Am I missing something ?
by dizdazdoz
16th Feb 2017 12:46pm
Valentines Day---Help From The Ladies
by fish5133
10th Feb 2017 7:35pm
Happy BirthdaY
by Vanmanone
10th Feb 2017 2:51am
Warning!!!
by muzzy2
9th Feb 2017 9:09am
New Wirral History
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
TS Indefatigable
by granny
18th Feb 2017 3:32pm
RIP : Chris Kay
by granny
31st Aug 2016 9:25am
Children's home on the Overchurch
by xleahx
26th Apr 2011 7:01pm
Stanlow Abbey
by ghostly1
4th Dec 2008 10:09pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Trump
by diggingdeeper
37 minutes 4 seconds ago
Stanlow Abbey
by ghostly1
50 minutes 27 seconds ago
vet fees
by eggandchips
Today at 12:03 PM
Patio work
by saltytom
Today at 07:02 AM
What song are you listening to?
by Vanmanone
Today at 02:59 AM
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
Tony Blair
by granny
Yesterday at 12:56 PM
Lion Salt Works/Weaver Hall Museum
by venice
Yesterday at 12:19 PM
TS Indefatigable
by granny
18th Feb 2017 11:28pm
February
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
Recent Posts : What's On ?
Lion Salt Works/Weaver Hall Museum
by venice
Yesterday at 12:19 PM
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
13th Feb 2017 8:50pm
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: 4972
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......


Looking for a Service / Tradesman? Look in our Local Business Directory. 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: 21011
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: 4972
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
vet fees
by eggandchips
Today at 12:01 AM
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
Lion Salt Works/Weaver Hall Museum
by paxvobiscum
18th Feb 2017 9:19pm
Patio work
by steamfan
18th Feb 2017 3:45pm
TS Indefatigable
by granny
18th Feb 2017 3:32pm
For Sale & Free
Gaming pc
by Cjoshea
18th Feb 2017 9:47pm
ESCHENBACH Illuminated Magnifiers
by buddy
15th Feb 2017 1:12pm
Canon EOS 550D + lenses & more
by j_demo
14th Feb 2017 4:24pm
Samsung NC10 Notebook PC
by gerrymoore
14th Feb 2017 3:55pm
Suitcase...never used. 2 wheels and sliding handle
by gerrymoore
14th Feb 2017 3:51pm
Featured Member
Registered: 9th Jul 2014
Posts: 506
Newest Members
Vkj530, SunsetP, RachelBinns, Rog0137, Iestyn
12221 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Lion Salt Works/Weaver Hall Museum
by paxvobiscum
18th Feb 2017 9:19pm
Patio work
by steamfan
18th Feb 2017 3:45pm
Ceiling needs smoothing
by yr20405
15th Feb 2017 1:52am
Info? Bill Dobson, Photographer, Martins Bank
by diggingdeeper
13th Feb 2017 12:10pm
War Museum
by missmahjong
12th Feb 2017 1:24pm
News : New Topics
Hezballah
by venice
17th Feb 2017 11:15am
On-street parking charges dropped
by oldpm01
15th Feb 2017 9:10am
Thousands raised for children of cancer couple.
by fish5133
13th Feb 2017 3:01pm
Lost ladies Swarovski watch
by spider
13th Feb 2017 10:36am
M53 closed in both directions between J2 and J3
by diggingdeeper
9th Feb 2017 10:00pm
New Enthusiast Forums
vet fees
by eggandchips
Today at 12:01 AM
Sea Shepherd
by venice
16th Feb 2017 1:06pm
Sounds of the Sixties
by paxvobiscum
11th Feb 2017 8:53pm
Hospital
by cools
10th Feb 2017 9:53am
X Box One S
by rossie
9th Feb 2017 8:56am
(Views 24hrs)Trending Newest Topics
vet fees 115
Seeking old pictures of Egerton Street area, Birkenhead 61
Wirral Sunrise Sunset
Sunrise Mon 7:18am
Sunset Mon 5:33pm
Local Time Mon 1:17pm
WikiWirral Can . . . .