Sort data using a custom list in PowerShell

Sometimes you might come across a situation where you'd like to sort a collection based on a custom list (similar to the feature available in Excel), rather than doing a basic sort based on the alphanumeric order of the property values using the Sort-Object cmdlet: The above doesn't really do the trick, if one would …

Using the Excel intersection operator

One of the lesser-known features of Excel is the intersection operator which can be used to simplify look-up operations. An intersection is the overlap of two or more cell ranges within excel. For instance: In the screenshot below the ranges C1:C5 and B3:D3 (Cell ranges in Excel are written by using the range operator ":") …

Run SQL against Excel and Access through Access Database Engine with PowerShell – Part 1

This is part 1 of a series of blog posts around using SQL against Excel and Access through ACE drivers (Access database engine) with PowerShell. Part 1 is about introduction and getting up and running. PowerShell has already some built-in support to slice and dice data via the select, where, and group cmdlets. If it …