Earlier in the week I had the privilege of presenting an introduction to Powershell\/PowerCLI webex to a group of VMware customers. To help explain the Where-Object, Select-Object, and Sort-Object cmdlets, I thought it would be helpful to create a Get-Beer function. This function was a success, so I thought I would share it here. The function is very basic — it uses Import-CSV to read information from a file and returns the results ordered by name. The results can then be piped to other functions for demo purposes.<\/p>\n
You can download a sample beer.csv file here<\/a>.<\/p>\n Here is the function:<\/p>\n The function type casts the numeric values as decimal so that they properly sort. To run this, place a beer.csv file in the C:\\tmp path (or adjust the filename\/path in the function), paste the function into a powershell window and you are ready to go.<\/p>\n Here are a few examples of what you can do with this function:<\/p>\n Earlier in the week I had the privilege of presenting an introduction to Powershell\/PowerCLI webex to a group of VMware customers. To help explain the Where-Object, Select-Object, and Sort-Object cmdlets, I thought it would be helpful to create a Get-Beer … Continue reading \r\n<#\r\n.SYNOPSIS\r\nList Miller Coors beer\r\n.DESCRIPTION\r\nThis function returns a list of beer bottled by MillerCoors.\r\nThe object also includes nutrition and alcohol information.\r\n.EXAMPLE\r\nPS C:\\> Get-Beer\r\n.NOTES\r\nThis function was created for demo purposes only. \r\nVMware PowerCLI rocks!\r\n#>\r\nFunction Get-Beer {\r\n\t$myResults = @()\r\n\tImport-Csv C:\\tmp\\beer.csv | Sort-Object Name | %{\r\n\t\t[decimal]$thisAlcoholPercent = $_.\"Alcohol%\"\r\n\t\t[decimal]$thisCaloriesPer12oz = $_.CaloriesPer12oz\r\n\t\t$myResults += new-object -type PSObject -Property @{\r\n\t\t\tName = $_.Name\r\n\t\t\tAlcoholPercent = $thisAlcoholPercent\r\n\t\t\tCaloriesPer12oz = $thisCaloriesPer12oz\r\n\t\t\tCategory = $_.Category\r\n\t\t} #End New-Object\r\n\t} #End for each object\r\n\t\r\n\t# Return a custom PS object containing each beer\r\n\treturn ($myResults | Select-Object Name, AlcoholPercent, CaloriesPer12oz, Category)\r\n} #End Function\r\n<\/code><\/pre>\n\r\nGet-Beer\r\n\r\n(Get-Beer).count\r\n\r\nGet-Beer | Sort-Object AlcoholPercent -Descending | Select-Object Name, AlcoholPercent -First 5\r\n\r\nGet-Beer | Where-Object {$_.CaloriesPer12oz -lt 200 -AND $_.Category -eq \"Craft\"} | Sort-Object AlcoholPercent -Descending | Select-Object -First 5\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"