Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

CSV and other delimited files - Scripting Blog [archived]

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 ...