1.    17 Sep 2017 #1
    Join Date : Mar 2016
    Posts : 157
    win 10 HOME

    print/save as .txt explorer search results


    Good Day all

    I'm hoping there is a way to save what explorer finds into a text file or even excel. i have a bunch of music scaterd on a few drives and would like to know what is where and sort out dupes

    all help is greatly appreciated

    I was able to do it with tree size but have lost the program i am out at sea now for three weeks or so, so no internet for a while. (for my laptop)
      My ComputerSystem Spec
  2.    17 Sep 2017 #2
    Join Date : Jan 2015
    UK, Midlands
    Posts : 11,002
    Win 10 Pro (1703)

    Search results to file: (path + file name)
    Export Windows 7 search results to a text file - Super User
    expands comment on this (for Win 7)
    Microsoft Community

    I doubt there's any change in this in Win 10.

    See
    http://www.thewindowsclub.com/print-...folder-windows
    and experiment with regular expressions with the DIR command
    e.g.
    DIR e*.mp3

    i have a bunch of music scaterd on a few drives and would like to know what is where and sort out dupes
    For that you'd be better waiting until you can download a comparison utility.
    E.g.
    How to Find and Remove Duplicate Songs
      My ComputerSystem Spec
  3.    17 Sep 2017 #3
    Join Date : Apr 2015
    Posts : 267
    Windows 10 Home x64 and Pro x86

    dmsel,

    1. Do the search,
    2. Select all the results [Ctrl-A does this quickly],
    3. Press the Shift key and, at the same time, right-click,
    4. Select Copy as path,
    5. Paste into Excel [a very good choice for this sort of task].


    Click image for larger version. 

Name:	sample Copy as path results.png 
Views:	8 
Size:	17.1 KB 
ID:	153826
    Sample results pasted into Excel

    Denis
      My ComputerSystem Spec
  4.    17 Sep 2017 #4
    Join Date : Jan 2015
    UK, Midlands
    Posts : 11,002
    Win 10 Pro (1703)

    Yes, that's in the first URL I posted. Thanks.
      My ComputerSystem Spec
  5.    17 Sep 2017 #5
    Join Date : Apr 2015
    Posts : 267
    Windows 10 Home x64 and Pro x86

    dmsel,

    When I was looking into saving music file lists, I developed an Excel tool that extracts Full path, Filename, File size, Album, "Authors" i.e. Artist [aka Album artist], Contributing artists, Genre, Year, #, Track title, Length, Bit rate

    The tool was a prototype but works well so I never rewrote it. You can download both the tool and a sample output file from my OneDrive Public folder [you can download them singly or together, if you do download them together OneDrive automatically zips them up into a single zip file].

    The extended properties this tool produces are much more than the basic Full paths & Filenames produced by Copy as path so might be what you were really after when you asked the question.

    Denis


    This tool produces an output workbook containing lists of files with their file paths & file properties for the folders & files entered in the Input worksheet.

    For Music files, the properties include Full path, Filename, File size, Album, "Authors" i.e. Artist [aka Album artist], Contributing artists, Genre, Year, #, Track title, Length, Bit rate

    This procedure is a real resource hog. Do not expect to be able to work on anything else while it is running.

    Whilst I have not encountered any problems with this version, I always close all other Excel files before running the procedure.

    This tool was developed for Excel 2007; it also works in Excel 2016 because VBA has changed so little.

    It was written for Windows 7 then extended for Windows XP; it also works in Windows 10.

    The VBA procedure was based on code provided by the MS Community contributors Mike H & Gary's Student and ExcelFox Forum contributor Rick Rothstein

    This is a 'prototype' from 2013. I never revised it because it works well enough as it is albeit a lot slower than it would be if I rewrote it now [my coding seems quite laughable now that I have studied VBA properly].

    It can cope with listing the whole of a Windows drive in Windows XP & Windows 7 but I have never extended it to cope with a whole Windows 10 drive because I never use it for such lists in practice. Windows drives are problematic because attempts to read the properties of several system files can be forcefully rejected by the system causing failure of the VBA procedure.

    Using it to list the whole of a Windows drive's contents can take all day.

    This tool is best limited to searching in user folders such as music folders.

    This Excel file is set to be read-only so that you do not accidentally keep Input sheet folder entries between runs.

    The screen does not update while the tool is running unless you turn the Development mode switch on. This allows you to see what it is doing but it slows the tool down a lot. Watching the procedure unfold is like watching paint dry.

    I have hidden rows in the Run this tool sheet for additional options that were never implemented
      My ComputerSystem Spec

 


Similar Threads
Thread Forum
Solved Windows 10 Explorer Search settings won’t save!
Hello there, I recently have this problem that my Options for the windows search won’t save anymore. That means that I always have to manually set them each and every time. Most of the time I use the search for Folders with a large amount...
General Support
File Explorer, different results for search then all folders set for
I have set all folders and subsfolders to view DETAILS - no matter what I do and I have spend three days searching for the answer - I cannot get a search result in Win 10 File explorer to show anything but the attached view. The search only always...
General Support
search results - cannot save view settings
Hi, I have to ask this because this is the most frustrating issue on Windows 10 to me. It really needs an update to fix this. When searching in a folder, the search results view is always "Content". If I want "Details" view, I have to...
General Support
Browsers & Email Show Cortana Web Search Results in Microsoft Edge or Internet Explorer
How to Show Cortana Web Search Results in Microsoft Edge or Internet Explorer When searching the web from Cortana on the taskbar, the Bing search results can display in Microsoft Edge (default) or Internet Explorer. If you use a screen reader,...
Tutorials
File Explorer Search: Results not opening
When I use File Explorer Search in my user folders, the results appear to have lost their association and do not open when I click them. Before search: 71513 After search for "Get" 71512 Note the icons have gone, the folder is not listed....
General Support
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 11:04.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums