WikiWirral is where great friendships are made.
Forum Stats
12328 Members
65 Forums
73256 Topics
989090 Posts
27 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
84 registered (alan128, 12 invisible), 1399 Guests and 276 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Finsbury Park mosque. 974
Round the Wirral with a movie camera[1934] 437
Code reader 322
Washing machine 199
Range Rover P38A Air Suspension Help Needed 143
Loving Home Wanted For 3 Cats. 117
Ant and Dec 97
Another Scam 79
Wanted roof box 65
Loving Home Wanted For 3 Cats. 59
New General Forums
Deja Vu, Lightning Strikes Thrice, Groundhog Day
by fish5133
07:38 PM
Ant and Dec
by cools
18th Jun 2017 2:11pm
Another Scam
by Excoriator
18th Jun 2017 10:00am
Happy birthday Ste
by Dilly
12th Jun 2017 7:54am
New Wirral History
Round the Wirral with a movie camera[1934]
by snowhite
16th Jun 2017 2:03pm
Bascule Bridge
by Sufee
6th Jun 2017 9:09pm
Pathe news short - merseytunnel 1934
by oldpm01
5th Jun 2017 1:57pm
1878 Post Office Directory of Cheshire query
by derekdwc
1st Jun 2017 10:41pm
Bakery at 275 Poulton Road 1925 onwards
by JAFitz
30th May 2017 8:59pm
Forum Tips
Photo Gallery Forums
wirral from Liverpool big wheel
New Brighton Big Wheel
Topic Replies
Where In The Wirral Is It??
by diggingdeeper
Yesterday at 09:22 PM
Benefit Cap is Unlawful
by RUDEBOX
Yesterday at 07:37 PM
Suspended sentence for 37,000 benefit fraud mum
by Mark
Yesterday at 06:45 PM
What song are you listening to?
by granny
Yesterday at 10:18 AM
live webcam from africa, a must see
by granny
Yesterday at 09:49 AM
VW t4 fixed side window replacement
by Mike72
Yesterday at 08:00 AM
Sailing volunteers
by diggingdeeper
Yesterday at 12:34 AM
Finsbury Park mosque.
by fish5133
21st Jun 2017 11:48pm
Bromborough Central Power Station
by Jimbo620
21st Jun 2017 7:19pm
June
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 ?
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
18th Jun 2017 11:41am
Sefton Park
by diggingdeeper
17th Jun 2017 7:28pm
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: 5015
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: 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: 21061
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: 5015
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
Benefit Cap is Unlawful
by RUDEBOX
07:37 PM
VW t4 fixed side window replacement
by Mike72
08:00 AM
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
For Sale & Free
Washing machine
by GingerTom
20th Jun 2017 9:05pm
22" full 1080p hd and freeview tv
by monsterz4
20th Jun 2017 8:50pm
Apple TV box the 1gen
by monsterz4
20th Jun 2017 8:48pm
42 lf smart tv
by stumpyduck
20th Jun 2017 8:15pm
Wanted roof box
by monsterz4
19th Jun 2017 10:32am
Featured Member
Registered: 15th Jun 2012
Posts: 7
Newest Members
Fairz87, mikerobbo84, Robbo1960, Gwhiz03, SamphireGreen
12328 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
15th Jun 2017 10:19pm
Sefton Park
by diggingdeeper
15th Jun 2017 10:02pm
Property Law
by lau2908
14th Jun 2017 8:04pm
van driver needed
by futurepast
14th Jun 2017 7:34pm
Sailing volunteers
by dogsbrain
14th Jun 2017 4:31pm
News : New Topics
Benefit Cap is Unlawful
by RUDEBOX
07:37 PM
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
Grenfell Tower - Notting Hill
by diggingdeeper
14th Jun 2017 5:13am
Manchester airport
by Dilly
9th Jun 2017 6:01pm
helicopter landing irby park
by fish5133
7th Jun 2017 12:22am
New Enthusiast Forums
VW t4 fixed side window replacement
by Mike72
08:00 AM
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Loving Home Wanted For 3 Cats.
by DavidC
18th Jun 2017 6:02pm
Code reader
by madrob
16th Jun 2017 9:09am
(Views 24hrs)Trending Newest Topics
Benefit Cap is Unlawful 35
VW t4 fixed side window replacement 28
Deja Vu, Lightning Strikes Thrice, Groundhog Day 19
Wirral Sunrise Sunset
Sunrise Fri 4:43am
Sunset Fri 9:45pm
Local Time Fri 6:09am
WikiWirral Can . . . .