{"id":12451,"date":"2011-10-09T00:01:00","date_gmt":"2011-10-09T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2011\/10\/09\/use-a-powershell-cmdlet-to-count-files-words-and-lines\/"},"modified":"2011-10-09T00:01:00","modified_gmt":"2011-10-09T00:01:00","slug":"use-a-powershell-cmdlet-to-count-files-words-and-lines","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-a-powershell-cmdlet-to-count-files-words-and-lines\/","title":{"rendered":"Use a PowerShell Cmdlet to Count Files, Words, and Lines"},"content":{"rendered":"

Summary:<\/strong> Learn how to use a powerful Windows PowerShell cmdlet to count words and lines in files, or to count files.<\/p>\n

 <\/p>\n

Microsoft Scripting Guy Ed Wilson here. The weekend is halfway over in Charlotte, North Carolina. For my friends in Australia, the weekend is already over, and they are on their way to work. Of course they get to start their weekend earlier than I do. The ideal thing to do is to be in Australia to start the weekend, and then pop back to Charlotte to conclude the weekend. Yes, I have strange thoughts on the weekend. For example, I was on the treadmill earlier, and I was thinking about my favorite Windows PowerShell cmdlet. Anyway, I called the Scripting Wife while I was cooling down. She was downstairs and it is easier to call her than to go down there. Cell phones make great intercoms.<\/p>\n

“What are you doing?” she asked as she answered her Windows 7 phone.<\/p>\n

“I just finished running on the treadmill, and I am now cooling down. I was wondering what your favorite Windows PowerShell cmdlet is.”<\/p>\n

“You have got to be kidding. Why would I have a favorite Windows PowerShell cmdlet?” she asked.<\/p>\n

“Well, I was thinking about my favorite Windows PowerShell cmdlet while I was running, and I realized I did not know what yours was,” I said.<\/p>\n

“Get-Real,” she said as she hung up.<\/p>\n

At times, I think that the Scripting Wife seems to believe I am a nerd. I am not positive of this and am somewhat afraid to ask, but she seems to give off the “nerd alert” vibe when I enter a room or when I call her on her cell phone from upstairs and ask her about her favorite Windows PowerShell cmdlet.<\/p>\n

Anyway, I will share my favorite cmdlet—it is the Measure-Object<\/b> cmdlet. If I did not have the Measure-Object<\/b> cmdlet, I would need to count the files in a folder manually. This is shown here:<\/p>\n

$i=0<\/p>\n

Get-ChildItem -Path c:\\fso -Recurse -Force |<\/p>\n

foreach-object { $i++ }<\/p>\n

$i<\/p>\n

 <\/p>\n

Using the Measure-Object<\/b> cmdlet, it is easy to count the files. I merely need to use the following steps.<\/p>\n

    \n
  1. Use the Get-Childitem<\/b> cmdlet to return a listing of fileinfo<\/b> objects. Use the recurse <\/i>switch to cause the cmdlet to work through subfolders. The force <\/i>switch is used to return any hidden or system files. Pass the path to count to the path <\/i>parameter.<\/li>\n
  2. Pipe the fileinfo<\/b> objects from step one to the Measure-Object<\/b> cmdlet<\/li>\n<\/ol>\n

    An example of using this command to count the files in the c:\\fso folder is shown here:<\/p>\n

    Get-ChildItem -Recurse -force | Measure-Object<\/p>\n

    The command and associated output are shown in the following figure. Note that I ran the command twice: the first time without the force <\/i>switched parameter, and the second time using it.<\/p>\n

    \"Image<\/a><\/p>\n

    But the Measure-Object<\/b> cmdlet does more than just count the number of files in a folder. It can also tell me information about a text file. A sample file is shown in the following figure.<\/p>\n

    \"Image<\/a><\/p>\n

    If I want to know how many lines are contained in the file, I use the Measure-Object<\/b> cmdlet with the line <\/i>switch. This command is shown here:<\/p>\n

    Get-Content C:\\fso\\a.txt | Measure-Object –Line<\/p>\n

    If I need to know the number of characters, I use the character <\/i>switch:<\/p>\n

    Get-Content C:\\fso\\a.txt | Measure-Object -Character<\/p>\n

    There is also a words <\/i>switched parameter that will return the number of words in the text file. It is used similarly to the character <\/i>or line <\/i>switched parameter. The command is shown here:<\/p>\n

    Get-Content C:\\fso\\a.txt | Measure-Object –Word<\/p>\n

    In the following figure, I use the Measure-Object<\/b> cmdlet to count lines; then lines and characters; and finally lines, characters, and words. These commands illustrate combining the switches to return specific information.<\/p>\n

    \"Image<\/a><\/p>\n

    One really cool thing I can do with the Measure-Object<\/b> cmdlet is to measure specific properties of the piped objects. For example, I can use the Get-ChildItem<\/b> cmdlet to return fileinfo<\/b> objects for all the text files in the folder. I can examine the length<\/b> property and find out the minimum length of the files in the folder, the maximum length, the average size, and the total length of all files in the folder. This command and associated output are shown here:<\/p>\n

    PS C:\\fso> Get-ChildItem -Filter *.txt | Measure-Object -Property length -Maximum -Minimum -Average -Sum<\/p>\n

     <\/p>\n

    Count    : 66<\/p>\n

    Average  : 305903.833333333<\/p>\n

    Sum      : 20189653<\/p>\n

    Maximum  : 12534760<\/p>\n

    Minimum  : 0<\/p>\n

    Property : Length<\/p>\n

     <\/p>\n

    If I want to, I can pipe the output to a table and create my own custom headings and output. In the following example, I display the average size of the files in kilobytes. I also define the format to omit decimal places:<\/p>\n

    PS C:\\fso> Get-ChildItem -Filter *.txt | Measure-Object -Property length -Maximum -Minimum -Average -Sum | ft count, @{“Label”=”average size(KB)”;”Expression”={($_.average\/1KB).tostring(0)}}<\/p>\n

     <\/p>\n

                                                          Count                      Average size(KB)<\/p>\n

                                                          —–                        —————-<\/p>\n

                                                             66                        299<\/p>\n

     <\/p>\n

    Well, that is about all there to say for now. The Measure-Object<\/b> cmdlet is one of my favorite cmdlets because it is easy to use and extremely flexible—an unbeatable combination in my book. What is your favorite cmdlet? Add a comment below and let me know. Until tomorrow, see ya.<\/p>\n

    I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

    Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n

    <\/b> <\/p>\n

    <\/b> <\/p>\n","protected":false},"excerpt":{"rendered":"

    Summary: Learn how to use a powerful Windows PowerShell cmdlet to count words and lines in files, or to count files.   Microsoft Scripting Guy Ed Wilson here. The weekend is halfway over in Charlotte, North Carolina. For my friends in Australia, the weekend is already over, and they are on their way to work. […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[38,51,3,4,12,45],"class_list":["post-12451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-getting-started","tag-scripting-guy","tag-scripting-techniques","tag-storage","tag-windows-powershell"],"acf":[],"blog_post_summary":"

    Summary: Learn how to use a powerful Windows PowerShell cmdlet to count words and lines in files, or to count files.   Microsoft Scripting Guy Ed Wilson here. The weekend is halfway over in Charlotte, North Carolina. For my friends in Australia, the weekend is already over, and they are on their way to work. […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=12451"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=12451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=12451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=12451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}