Scripting Blog [archived]

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

PowerTip: Create Custom Names for CSV File

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

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

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