Welcome to WikiWirral, sharing is what we do best.
Forum Statistics
Forums65
Topics76,352
Posts1,033,281
Members14,560
Most Online16,551
Feb 2nd, 2024
Who's Online Now
10 members (ArranGirl13, 3 invisible), 8,027 guests, and 431 robots.
Key: Admin, Global Mod, Mod
Top Posters
sunnyside 45,164
MattLFC 22,315
Mark 21,269
granny 17,788
_Ste_ 16,345
Newest Members
Kalena1962, rattus, Lisrush, Emotecreative, ArranGirl13
14,560 Registered Users
New General Forums
New Wirral History
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
D.I.Y. / Building Shop
by mharford91 - 3rd Mar 2024 8:53pm
1970's Murder in Central Park, Wallasey
by cutespam - 4th Aug 2018 10:28am
Old Hall in Higher Bebington
by Rhoobarb - 25th May 2010 5:55pm
Oleo Works
by Ducko - 14th May 2008 3:09pm
Top Posters(30 Days)
granny 14
casper 13
bri445 4
Topic Replies
What song are you listening to?
by diggingdeeper - 28th Mar 2024 6:06pm
Facial recognition coming in supermarkets?
by diggingdeeper - 27th Mar 2024 3:50pm
Bolts at Bebington Road
by diggingdeeper - 27th Mar 2024 2:33am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Tall Brick Chimneys
by diggingdeeper - 26th Mar 2024 5:43pm
Lost river (Well, brook really)
by diggingdeeper - 26th Mar 2024 3:09am
Old Hall in Higher Bebington
by diggingdeeper - 24th Mar 2024 5:58pm
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
March
M T W T F S S
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
Top Likes Received (30 Days)
Kylix 1
cools 1
Top Likes Received
bert1 14
Mark 4
granny 3
casper 3
Previous Thread
Next Thread
Print Thread
Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
I would like to have a prog(pref free) that does something similar to search in XP where if I search for .jpeg for example it brings up a list of all the .jpegs on that hard drive. Is there any way of making the search list into an excel file

Last edited by derekdwc; 10th Mar 2012 3:35pm.
Google Ads
Joined: Apr 2011
Posts: 1,337
Forum Addict
Offline
Forum Addict
Joined: Apr 2011
Posts: 1,337


-----
1337
Joined: Dec 2008
Posts: 5,444
Forum Veteran
Offline
Forum Veteran
Joined: Dec 2008
Posts: 5,444
used to work with msdos but I used to use wild card plus file extension i.e. *.jpg and it would find the lot. Don't know what part of the memory bank that was dragged up from.


Birkenhead........ God's own Room 101.
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
What do you want to do with the list ?
As that could be the decider and advice to follow.

think

Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
I've got several external hard drives and I've copied various folders of pics to them sometimes duplicating a folder at a later date which had extra pics in, so I want to make a list of them to find what drives they're on.
Also got lots of ebooks that are in folders by author but would like a list by book title but without having to open each foler,
At the moment I am using Treesize Pro and ACDC but that means going through one folder at a time.
Ideally I'd like to have excel lists of all my .mp3s, .jpegs and .mobi

Last edited by derekdwc; 11th Mar 2012 12:39pm.
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
What OS are you using? Operating System ?

As that can help too.

There are Duplicate Finding programs out there.

Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
XP on one pc and windows 7 on another.
Ideally what comes up in the start-search- jpeg in Xp would be great if I could make a list from that

Last edited by derekdwc; 11th Mar 2012 12:43pm.
Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
Progs that other members have used and can recommend would be helpful - free ones and even paid for ones

Joined: Apr 2011
Posts: 1,337
Forum Addict
Offline
Forum Addict
Joined: Apr 2011
Posts: 1,337


This does what you're asking for.

I don't know of anything that'll dump lists into excel because I don't know anyone that would use excel in that way. It'll drop the list into a .txt though and you could then try and find a way to shove that into excel .. though I don't know why you'd want to.

Excel isn't built for lists or meant to be used that way.


-----
1337
Joined: Oct 2008
Posts: 5,210
Forum Veteran
OP Online Content
Forum Veteran
Joined: Oct 2008
Posts: 5,210
thanks exO just tried that program, it's ok on windows 7 but will not load into XP.
I like to do various sorts A-Z and data advanced filters in excel. I'm not any good on databases

Joined: Oct 2011
Posts: 68
Member
Offline
Member
Joined: Oct 2011
Posts: 68
Originally Posted by derekdwc
thanks exO just tried that program, it's ok on windows 7 but will not load into XP.

Have you tried installing the visual basic runtimes at the bottom of the page.
Or you could try http://www.nirsoft.net/utils/search_my_files.html You can save the output as csv and import them into excel.

Joined: Aug 2007
Posts: 2,990
Are you SoNutz?
Forum Master
Offline
Are you SoNutz?
Forum Master
Joined: Aug 2007
Posts: 2,990
Theres also the old fasioned way of doing it.. Start / Run / Cmd in the Command Prompt screen do the following....

__________________________________________________________________
Microsoft Windows XP blah blah
Version Blah Blah

Type the Following
"C:\>"cd\(directory you want to list) or if you want to do the whole drive just type cd\

"C:\>"dir *.jpg /a/s >dump.txt

now this will search the whole drive for JPG files and dump them in the Dump.txt.. You can then open notepad and goto c:\dump.txt and it will have the list of the JPGS in there.. You could then copy and use paste special in the Excel Spreadsheet to add them all. To search the whole listing press CTLR - F and use the find function..

IF this is too technical for you then im sure someone on here will be of help but this is how i search for files if i cant be bothered using the stupid windows search.. as that DIR command above removes all attributes and search each individual directory and its great if you search for one file for example..

"C:\>" dir photo1.jpg /a/s >dump.txt
or you can leave the >dump.txt out and it'l show you on the CMD screen.. Anyway thats the way i would search for something.. Sorry if its too over the top.. Hope this helps..


Lee Mills

Joined: Apr 2011
Posts: 24
Newbeee
Offline
Newbeee
Joined: Apr 2011
Posts: 24
Hi,

You might want to take a quick look at Glary Utilities. It has a free version as well as a paid for Pro version. I'm using Pro but had a quick look at their website for the free version and the things I mention below appear to be in there.

Firstly, this is a tremendous free application for general PC maintenance - it has a simple one click option for undertaking automated routine clean up. I've been using it for years and it helps keeps my PC's free from clutter both at the file and registry level.

With respect to your specific q's - I think it will do what you want but not in the way you envisage - actually I think it might be better for you, if I understand your requirements correctly:

Under the Modules / Files and Folders section is a Disk Analysis option. This performs a summary analysis by folder, disk or multiple disks depending on the search / scan critieria you select. The explorer like interface then visualises:-

1) Which folders are using the most / least space
2) A summary of each file type i.e the total size of each file type by folder / disk(s). So for example on my PC right now I can see that I have 1.13GB of .jpg files on my C drive in 17234 files! (they are mostly small web design image / icons)
3) By clicking/selecting on the file type a sub pane in the interface lists all of those files (and if you initially analysed multiple disks then it would present them across all disks). I can order the files my name, location, size etc in the usual Explorer way.
4) The appllication also includes an inherent link to Windows Explorer - so once you have identified the appropriate file you can easily delete / rename etc. without having to leave the main app or rescan.

I think this might be better as with this approach you get "live" files update as you scan. With the excel approach everytime you added / delete files you would need to manually search and copy / paste update Excel. Then you would need to do what you wantedneeded to do in Excel and then manually locate the file you wanted to make changes on in Windows Explorer which is pretty tiresome and labour intensive.

Incidentally, another module included in the main utility app is a duplicate files finder. I've not had the need to play with that yet but that might also help you out.

Hope this makes sense, it's a bit difficult describing the functionality exactly but I suggest you give it a try as it's free, it is pretty simple and intuative to use and even if it doesn't solve the problem you mention (but I think it does, as I use it in a similar way to control my mp3 files), it's still a fantastic clean up utility.

Cheers,

Neston


Moderated by  Mark 

Link Copied to Clipboard
Random Wirral Images

Click to View Topic.
Newest Topics
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
For Sale & Free
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
This is Elvis
by GingerTom - 17th Mar 2024 2:37pm
Member Spotlight
Dilly
Dilly
wallasey
Posts: 8,973
Joined: July 2011
Today's Birthdays
There are no members with birthdays on this day.
New Wirral Info
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Get your Money Tree ready
by keef666 - 22nd Mar 2023 12:27pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM - 7th Aug 2020 7:59pm
News : New Topics
Gaza
by diggingdeeper - 29th Oct 2023 9:28am
Lost river (Well, brook really)
by Excoriator - 10th Sep 2019 8:50am
New Enthusiast Forums
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Xbox
by TudorBlue - 3rd Mar 2024 8:48pm
Wiper mechanism needed
by Peter0787 - 20th Feb 2024 4:07pm
What song are you listening to?
by - 24th Jun 2007 9:06am
Popular Topics(Views)
5,069,755 WIKI WALK CHAT
4,013,812 Spotted!
Powered by UBB.threads™ PHP Forum Software 7.7.5