PowerShell - List File Line Count For Files in a Directory that Match a Given Pattern

I had a need to get the total count of all lines, for a given set of .csv files. For example, there are 5 files each with 1000 lines, I wanted a script that would output: 1000, 1000, 1000, 1000, 1000.

I could not find a script or command to do this, so I wrote one in PowerShell. Enjoy


List File Line Count For Files in a Directory that Match a Given Pattern

https://gist.github.com/aaronhoffman/416b88e64b970c4c9cb4


hope this helps,
Aaron
Post a Comment

Popular posts from this blog

How to Turn Off Microsoft Arc Touch Mouse Scroll Sound Vibration

Image
I recently purchased a Microsoft Arc Touch Mouse and wanted to turn off the middle button wheel scroll sound vibration.

It is possible, however perhaps not obvious.  First you need to download the "Mouse and Keyboard Center" executable available on this page http://www.microsoft.com/hardware/en-us/p/arc-touch-mouse#support.

(direct link Win8 x64: http://download.microsoft.com/download/F/4/7/F470FE38-7D5E-4BE2-BCA1-E333C28027A0/MouseKeyboardCenter_64bit_ENG_2.3.188.exe )


Run the executable and install the software.  After the software is installed, turn off "Vibration." See image below:




Hope this helps,
Aaron


p.s.  Want to make that next report really pop?

Check out this new tool I'm working on:






Read more

Hacker News Dataset October 2016

Image
Our latest project on Sizzle is a visualization of the Top 10k Posts of All Time on Hacker News.



To create the visualization, we first needed to collect the data.

I noticed that there was an old copy of the hacker news dataset available on Big Query. But I needed an up-to-date copy, so I looked into the Hacker News Firebase API.

The API allows you to get each item by Id. You can start by retrieving the current Max ID, then walking backwards from there. (Items my be stories, comments, etc., it's the same API endpoints for all types of items.)

There is no rate limit, so I created the following script that will generate a text file with 10MM lines containing all of the URIs to retrieve. (we will then feed this file into wget using xargs)

Note: 10MM items was ~5 years worth of data.

Script to create the 10MM line file of URIs to retrieve:
https://gist.github.com/aaronhoffman/1f753c660d7364bb594a36af350b227c

That script takes about 10 minutes to produce a file that's around 560MB in…
Read more

VirtualBox Right-Click Windows Taskbar On Mac

Using VirtualBox on my Mac (in windowed mode, not full screen), I noticed that right-click on the Windows taskbar was not working. I commonly use right-click on the task bar to launch an application as administrator, pin an application to the taskbar, etc. I could two-finger click on other windows to get the right-click menu to appear, but that did not work on the taskbar.
To get the right-click menu to appear on the windows taskbar, I had to hold down the "host key" which for me was the left Mac command key, and single-finger click the item in the taskbar.

Hope this helps! Aaron
Read more