WikiWirral is where great friendships are made.
Forum Stats
12185 Members
65 Forums
72609 Topics
978424 Posts
89 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
90 registered (11kendo, 15 invisible), 1513 Guests and 195 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Secretive mega shake-up of NHS could cost 15 mil 654
Found a mobile phone 14/01/2017 WALLASEY 398
Asbestos shed removal 379
Paypal help 376
Sometimes You Could Strangle Someone 363
When we live to be a 100 yrs old 327
RAC ,AA v Breakdown Recovery 323
Best Price for Scarpping my car 298
Spy in the wild 296
Lost Mobile Phone 288
New General Forums
Test on old english words
by derekdwc
Jets
by cools
12:14 PM
The Scouse Accent
by palemoon
18th Jan 2017 7:49pm
birthday wishes
by sunnyside
18th Jan 2017 12:48pm
New Wirral History
753 Sea Horse, Unit 9, Wallasey Waterfront
by Norton
18th Jan 2017 9:07pm
What was County Hall, Abbey Street, Birkenhead?
by yoller
15th Jan 2017 1:28pm
752 The Old Manor Club, Withens Lane, Liscard
by Norton
13th Jan 2017 2:20pm
751 Plough Inn, Mount Pleasant Rd, New Brighton
by Norton
13th Jan 2017 1:38pm
351 Prince Alfred 30 Tunnel Road 30 30 to 32
by yoller
8th Jan 2017 7:18pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Melamine faced chipboard ( Walnut or Oak )
by Reno37
0 seconds ago
Tasering Again
by cools
18 minutes 19 seconds ago
What song are you listening to?
by starakita
20 minutes 23 seconds ago
Paper Recycling. ?
by fish5133
28 minutes 39 seconds ago
Parking Charges
by 8HBob
Today at 06:48 PM
Trump
by granny
Today at 06:35 PM
Animal Cruelty in the Film Industry
by cools
Today at 06:06 PM
Musicals
by granny
Today at 02:49 PM
Taylors Villas 1874 any info?
by joney
Today at 02:20 PM
January
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 ?
Indian/Jazz fusion music Liverpool
by buddy
17th Jan 2017 9:46am
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
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: 4965
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: 21001
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: 4965
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
Animal Cruelty in the Film Industry
by granny
12:00 PM
Question Time
by derekdwc
11:27 PM
Sanctuary awaits 5 bears
by venice
06:25 PM
Parking Charges
by diggingdeeper
03:01 PM
Kitten found Arrowe park car park
by Greenwood
02:42 PM
For Sale & Free
Melamine faced chipboard ( Walnut or Oak )
by Reno37
Today at 11:36 AM
Wanted freezer kit
by dodie
18th Jan 2017 9:58pm
2pioneer speakers Free
by dodie
18th Jan 2017 9:54pm
Looking to swap an xbox one for a ps4
by surykata
18th Jan 2017 8:10pm
Wanted old cars spares or repairs
by vw_kyle
17th Jan 2017 1:08pm
Featured Member
Registered: 10th Nov 2003
Posts: 3793
Newest Members
Glenburn63, Branco, Smudge22, Collette63, shellylou
12185 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Paper Recycling. ?
by fish5133
11:16 AM
Paypal help
by venice
17th Jan 2017 8:59pm
Brown Bin Collections Restarting Today 17th Jan
by fish5133
17th Jan 2017 9:04am
Indian/Jazz fusion music Liverpool
by paxvobiscum
15th Jan 2017 11:19am
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
News : New Topics
Tasering Again
by diggingdeeper
Today at 06:14 PM
Trump
by cools
Today at 04:16 PM
Nuns Abused Children in Care Homes.
by granny
Today at 12:13 PM
Parking Charges
by diggingdeeper
Yesterday at 03:01 PM
Spectacles found.
by Beethoven
18th Jan 2017 1:02pm
New Enthusiast Forums
Animal Cruelty in the Film Industry
by granny
Today at 12:00 PM
Question Time
by derekdwc
Yesterday at 11:27 PM
Sanctuary awaits 5 bears
by venice
Yesterday at 06:25 PM
Kitten found Arrowe park car park
by Greenwood
Yesterday at 02:42 PM
Puppy wanted good careing home offered
by chris7777
Yesterday at 09:07 AM
(Views 24hrs)Trending Newest Topics
Trump 204
Question Time 195
Animal Cruelty in the Film Industry 115
Nuns Abused Children in Care Homes. 67
Tasering Again 64
Melamine faced chipboard ( Walnut or Oak ) 50
Jets 25
Wirral Sunrise Sunset
Sunrise Fri 8:13am
Sunset Fri 4:33pm
Local Time Fri 8:06pm
WikiWirral Can . . . .