The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

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

PowerTip: Create Custom Names for CSV File

August 26, 2014 Aug 26, 2014 08/26/14

Doctor Scripto

Summary: Use Windows PowerShell to create custom column headings. (image) How can I use Windows PowerShell to generate custom heading for a CSV file when I import it? (image) Specify the –Header parameter as an array of names in the order of the fields, for example: Import-CSV c:\fso\myfile.csv –delimiter “:&rdquo...

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

PowerTip: Use PowerShell to Read Tab Delimited File

August 25, 2014 Aug 25, 2014 08/25/14

Doctor Scripto

Summary: Use Windows PowerShell to read a Tab delimited file. (image) How can I use Windows PowerShell to read a Tab delimited file? (image) Use the Import-CSV cmdlet and specify a delimiter of `t, for example: $a = Import-Csv -Delimiter "`t" -Path c:\fso\mytabfile.tsv (image...

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

PowerTip: Find Cmdlets that Need TimeSpan Object

August 24, 2014 Aug 24, 2014 08/24/14

Doctor Scripto

Summary: Use Get-Command to find cmdlets that need a TimeSpan object for input. (image) How can I use Windows PowerShell to find which cmdlets will accept a TimeSpan object for input? (image) Use the ParameterType parameter from the Get-Command cmdlet, for example: Get-Command -...

Scripting Blog [archived]

August 2014 - Page 3 of 13 - Scripting Blog [archived]