Using PowerShell Import-Csv – Looping with foreach – Part 2

Welcome to the continuation of our series on using the PowerShell function Import-CSV.  In part 1 of this series we touched on the basics of using the Import-Csv CmdLet by reading a file into an array variable and extracting elements and data from our input data. Looping with PowerSehll Import-CSV foreach To enhance this process … Read more

PowerShell and the Import-Csv CmdLet – A New PowerShell Series

Managing data inside a CSV file is surprisingly simple thanks to the PowerShell Import-CSV CmdLet. I’m often presented with data from different sources in a variety of formats, and by and large the common format used for data extracts is CSV. Regardless of the system that generates the content, we can all render and consume data … Read more

The Rise of the Generalist

If I could paraphrase the title of the Anthony Robbins powerfully popular book, I would pen one myself named “Awaken the Consultant Within”. There are many paradigm shifts in technology and business. Some are cyclic, and some are simply evolving methods which gain strength for varying durations. What had become a strong trend in the … Read more

Are you sure? Using the -WhatIf and -Confirm parameters in PowerShell

There are 2 very helpful parameters you can apply to many PowerShell CmdLets. These are the –WhatIf and the –Confirm options. There are many cases where you are processing a number of records which you would like to get an idea on how to “test drive” the process on a large chunk of data.  First, by utilizing the –WhatIf parameter … Read more