Dispay file name, size, and directory path all on one line? Solved

Page 2 of 2 FirstFirst 12
  1.    #11

    dalchina said: View Post
    Once upon a time an OS was an operating system, and provided a level of abstraction from the hardware and very basic utilities. People then used programs- applications- which performed particular tasks- applying the computer to a particular task.

    I find it interesting that applications may now be regarded as 'clutter', although too many of them certainly could.

    Further applications with a GUI provide another layer of abstraction, providing features that are usable without a manual, reference sheet or a good memory.

    I suppose you might allow someone to install an Office suite, even though Windows has Notepad and Wordpad?

    But as you say, it's all a matter of choice- some may remember the good old days of UNIX...
    Definitely the OS should have been what its name implies and tasks should be done by applications.

    It's a fact though that each user should have the option to choose what he/she feels comfortable with. And I'm not talking about Office and Wordpad, as they're not comparable feature wise.
    But at system level, more advanced users need the freedom the good old command line offers, at the expense of a nice looking GUI, which has the limitations its developer has imposed.

    The other day I was discussing with my daughter the way SAP provides to query its database... everything "should" be done via GUI. As an older user, I prefer the flexibility SQL provides...at the expense of having a side note of all the available fields/columns.

    And, I could never argue with that :
    Further applications with a GUI provide another layer of abstraction, providing features that are usable without a manual, reference sheet or a good memory.
    Bottomline, as we both agreed, it's a matter of preference!
    Last edited by ddelo; 16 Jun 2019 at 11:40.
      My ComputerSystem Spec

  2.    #12

    jimbo45 said: View Post
    Hi there.

    even good old dos command will do it -- simply output to a .txt file and open in Excel !!!!

    Cheers
    jimbo
    I tried using the dir command with different switches and no combination would give me everything I needed on one line.
    The whole idea was to avoid editing a text file that is dir command output. Ultrasearch did that.
      My ComputersSystem Spec

  3.    #13

    x509 said: View Post
    I tried using the dir command with different switches and no combination would give me everything I needed on one line.
    The whole idea was to avoid editing a text file that is dir command output. Ultrasearch did that.
    As an alternative to the excellent utility proposed by @dalchina, you can use the follow command, in PowerShell to get what you need.

    Code:
    Get-ChildItem -Path 'C:\Users\Dimitri\Sysinternals' -Recurse -Force -File -Filter * -ErrorAction SilentlyContinue | sort Directory, Name | Select-Object @{L="FileType";E={ (Get-ItemProperty "Registry::HKEY_CLASSES_ROOT\$((Get-ItemProperty "Registry::HKEY_CLASSES_ROOT\$($_.Extension)")."(default)")")."(default)" }}, Length, LastWriteTime, @{L="Version"; E={$_.VersionInfo.ProductVersion}}, Directory, Name | Export-CSV $HOME\Desktop\FileList.csv -Encoding utf8 -NoTypeInformation
    In my example I search the Sysinternals folder in my HOME path, recursing all subfloders and including Hidden/System/ReadOnly files and the list is saved in the Excel csv file FileList.csv on my Desktop.

    The output of the command, on screen looks like that:

    Click image for larger version. 

Name:	FileList.png 
Views:	3 
Size:	137.8 KB 
ID:	237573


    The -Path parameter should be changed to your search path, the -Filter parameter can be changed to anything you look for (e.g. *.exe, *.png, *. txt etc) and you can omit the -Force parameter if you're not looking for Hidden/System/ReadOnly files.

    HTH.
      My ComputerSystem Spec

  4.    #14

    ddelo said: View Post
    As an alternative to the excellent utility proposed by @dalchina, you can use the follow command, in PowerShell to get what you need.

    Code:
    Get-ChildItem -Path 'C:\Users\Dimitri\Sysinternals' -Recurse -Force -File -Filter * -ErrorAction SilentlyContinue | sort Directory, Name | Select-Object @{L="FileType";E={ (Get-ItemProperty "Registry::HKEY_CLASSES_ROOT\$((Get-ItemProperty "Registry::HKEY_CLASSES_ROOT\$($_.Extension)")."(default)")")."(default)" }}, Length, LastWriteTime, @{L="Version"; E={$_.VersionInfo.ProductVersion}}, Directory, Name | Export-CSV $HOME\Desktop\FileList.csv -Encoding utf8 -NoTypeInformation
    In my example I search the Sysinternals folder in my HOME path, recursing all subfloders and including Hidden/System/ReadOnly files and the list is saved in the Excel csv file FileList.csv on my Desktop.

    The output of the command, on screen looks like that:

    Click image for larger version. 

Name:	FileList.png 
Views:	3 
Size:	137.8 KB 
ID:	237573


    The -Path parameter should be changed to your search path, the -Filter parameter can be changed to anything you look for (e.g. *.exe, *.png, *. txt etc) and you can omit the -Force parameter if you're not looking for Hidden/System/ReadOnly files.

    HTH.
    Ddelo,

    I wish I had seen your post earlier. yes, that would have helped, but honestly, I haven't managed to find the time to learn PS. It's on my "list," but I'm not an IT guy, so knowing PS isn't a must for me. I know that PS runs rings around the DOS cmd commands, but at least I know those.

    x509
      My ComputersSystem Spec

  5.    #15

    x509 said: View Post
    Ddelo,

    I wish I had seen your post earlier. yes, that would have helped, but honestly, I haven't managed to find the time to learn PS. It's on my "list," but I'm not an IT guy, so knowing PS isn't a must for me. I know that PS runs rings around the DOS cmd commands, but at least I know those.

    x509

    You can use this command, if you wish, for future searches and based on this one and your new needs, you can start googling to learn more things, little by little. It's not easy, especially for non-technical people to learn it, but it can provide flexibility for lots of things.

    PS is a very rich tool and it's not something that you and I will ever say that we "know". Even PS gurus learn new things everyday.

    So, in a nutshell, you can always search this excellent forum or ask a question and you have a great chance to get an answer, that will solve your problem.

    Take care. Dimitri
      My ComputerSystem Spec

  6.    #16

    x509 said: View Post
    Dalchina,

    I just tried out Ultrasearch, including the option to export to Excel. Fantastic. I'm one happy camper.

    Solved.
    I've been using Ultrasearch for more thjan a week now. +5 over the built-in Windows Explorer search. I keep it running all the time now.
      My ComputersSystem Spec



 
Page 2 of 2 FirstFirst 12

Related Threads
I have an old program that runs well on Windows 10, except for one problem: it resets the directory font size to teeny-tiny and I have to reboot to get back the default size. That tiny size also makes it difficult to move things because I can't...
I'm trying to ascertain the size of my User folder. Right clicking on C:\Users\myusername directory shows 297 GB, however, I know it is much larger than that; a certain folder within my User folder, for example, is over 400GB. I believe the size of...
Hi All, Any way to get/display the full path and file name of a file? It's easy to get the full path, but I want to get the path and file name. I know I can grab them separately. Can I get them together? How? I did a google and youtube search...
I have a 16 mg image, 4500x3000. I resized all the way down to 100x100 and the file size won't change from 12.4 or so. This is true for all photos in a certain file I downloaded from online. They are appliance products. I tried downloading a...
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 18:50.
Find Us