WikiWirral its great, register, enjoy and welcome.
Forum Stats
12132 Members
65 Forums
72375 Topics
975992 Posts
64 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
83 registered (11kendo, 13 invisible), 1547 Guests and 209 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Disgusting surely not legal creamfields noise !!@ 1221
anything with castors 792
Pensby Hotel 459
Wirral Globe 422
loud music in new brighton 412
Sports Personality Of The Year 367
Cubitts Holland and Hannen 311
Raspberry Pi in the classroom! 296
PC Repair needed 265
HMT Lancastria 190
New General Forums
Lib/dems rule the day
by JimmyG
Yesterday at 10:59 PM
Daft funny joke
by venice
Yesterday at 05:54 PM
We dont learn much.
by venice
1st Dec 2016 9:22pm
Freegle
by venice
1st Dec 2016 6:36pm
New Wirral History
Name help
by Paternoster21
Today at 08:03 AM
HMT Lancastria
by granny
Yesterday at 11:38 PM
Cubitts Holland and Hannen
by fish5133
27th Nov 2016 5:38pm
Fire station
by chris7777
22nd Nov 2016 12:24pm
Buy a house in Greasby for 12s a week - in 1935
by yoller
6th Oct 2016 6:56pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Name help
by Greenwood
04:29 PM
live webcam from africa, a must see
by granny
04:05 PM
HMT Lancastria
by granny
02:06 PM
Stanlow Abbey
by Kylix
02:05 PM
Sports Personality Of The Year
by fish5133
01:16 PM
Raspberry Pi in the classroom!
by diggingdeeper
12:45 AM
Wirral Globe
by Excoriator
11:02 PM
What are you currently reading?
by RUDEBOX
10:30 PM
Paying for EU Citizenship (Poll)
by diggingdeeper
10:19 PM
December
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 ?
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
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: 4945
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: 20958
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: 4945
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
Name help
by Paternoster21
Today at 08:03 AM
HMT Lancastria
by granny
Yesterday at 11:38 PM
Wirral Globe
by locomotive
1st Dec 2016 6:25pm
54 plate renault clio 3rd brake light
by Mike72
1st Dec 2016 12:52pm
Raspberry Pi in the classroom!
by FelixCowden
30th Nov 2016 9:27pm
For Sale & Free
Steam Train Money Box/Ornaments
by Tranquil
1st Dec 2016 11:32am
Childs LFC Bike 5 - 8 Yr old
by Pete_M
1st Dec 2016 1:10am
Cat related Collectables
by Tranquil
29th Nov 2016 4:48pm
original xbox
by vw_kyle
27th Nov 2016 8:17pm
anything with castors
by lincle
27th Nov 2016 4:06pm
Featured Member
Registered: 18th Apr 2011
Posts: 628
Newest Members
Grayo123456, uptonvillage, NobbyHunt, sam1512, ant72
12132 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Wirral Globe
by locomotive
1st Dec 2016 6:25pm
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
A job. Company not named.
by venice
30th Nov 2016 6:30pm
Santa's Grotto at Tam O'Shanter 11th Dec.
by Greenwood
29th Nov 2016 1:44pm
News : New Topics
Pensby Hotel
by granny
29th Nov 2016 6:39pm
Paul Nuttall Elected UKIP leader
by granny
28th Nov 2016 12:03pm
Disgusting surely not legal creamfields noise !!@
by svenlock68
27th Nov 2016 8:25am
Paying for EU Citizenship (Poll)
by diggingdeeper
26th Nov 2016 12:35pm
Footballers--Abused
by fish5133
25th Nov 2016 3:46pm
New Enthusiast Forums
54 plate renault clio 3rd brake light
by Mike72
1st Dec 2016 12:52pm
Raspberry Pi in the classroom!
by FelixCowden
30th Nov 2016 9:27pm
crop loss & water rationing in Dominican Republic
by FelixCowden
30th Nov 2016 8:46pm
PC Repair needed
by TudorBlue
29th Nov 2016 2:54pm
Sports Personality Of The Year
by fish5133
29th Nov 2016 12:32am
(Views 24hrs)Trending Newest Topics
HMT Lancastria 190
Name help 131
Lib/dems rule the day 30
Daft funny joke 28
Wirral Sunrise Sunset
Sunrise Sat 8:09am
Sunset Sat 3:55pm
Local Time Sat 5:41pm
WikiWirral Can . . . .