print/save as .txt explorer search results

  1. dmesal's Avatar
    Posts : 261
    win 10 HOME
       #1

    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 Computer

  2. dalchina's Avatar
    Posts : 31,318
    Win 10 Pro (1903)
       #2

    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 Computers

  3. Try3's Avatar
    Posts : 8,371
    Windows 10 Home x64 Version 21H1 Build 19043.1052
       #3

    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].


    print/save as .txt explorer search results-sample-copy-path-results.png
    Sample results pasted into Excel

    Denis
      My Computer

  4. dalchina's Avatar
    Posts : 31,318
    Win 10 Pro (1903)
       #4

    Yes, that's in the first URL I posted. Thanks.
      My Computers

  5. Try3's Avatar
    Posts : 8,371
    Windows 10 Home x64 Version 21H1 Build 19043.1052
       #5

    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 Computer


 

  Related Discussions
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 23:13.
Find Us




Windows 10 Forums