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

dalchina said:

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!

jimbo45 said:

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.

x509 said:

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:




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 said:

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:




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

x509 said:

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

x509 said:

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.