Scripting Blog

A place to learn about PowerShell and share stories of automation

CSV and other delimited files - Scripting Blog

Use PowerShell to Work with Data from MS OMS

January 14, 2016 Jan 14, 2016 01/14/16
Doctor Scripto
Summary: Ed Wilson, Microsoft Scripting Guy, talks about using Windows PowerShell to parse data obtained from Microsoft Operations Management Suite. Microsoft Scripting Guy, Ed Wilson, is here. One of the things I have been working on a lot the past month is the new Microsoft Operations Management Suite Blog. For one thing, it is on the new ...

PowerTip: Get Row from CSV File Based On Value

February 19, 2015 Feb 19, 2015 02/19/15
Doctor Scripto
Summary: Use Windows PowerShell to get a row from a CSV file based on a specific value.  How can I use Windows PowerShell 4.0 to look up a specific row from a CSV file I imported into a variable?  Use the Where method, and use a match pattern to search on a specific column and value, for example: $topics = import-csv -...

Use PowerShell to Fix Date from CSV File

August 26, 2014 Aug 26, 2014 08/26/14
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to fix the date in a CSV file prior to data export. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sipping a cup of English Breakfast tea. I added a cinnamon stick and a bit of lemon grass to the pot. Of course before I did anything, I primed my ...

Use PowerShell to Read Munged Data

August 25, 2014 Aug 25, 2014 08/25/14
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell with munged data. Microsoft Scripting Guy, Ed Wilson, is here. Last week, the Scripting Wife and I had the opportunity to attend the Charlotte SQL Users Group. This is always a highlight, because that user group is one of the largest SQL User Groups around. I was...

PowerShell Mini-Scripting Games 2014: Answer 2

August 19, 2014 Aug 19, 2014 08/19/14
Doctor Scripto
Summary: Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline. Problem 2 synopsis You have a CSV file that contains five ...