Showing archive results for 2014

Summary: Use Windows PowerShell to fix address issues prior to exporting the data to another database. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am listening to The Doors on my Zune HD, and sipping a very nice cup of tea. I used three spoons of Darjeeling tea, one spoon of lemon grass, one spoon of marshmallow root, one spoon of l...

Summary: Learn how to use Windows PowerShell to change the system time. The clock on my computer (running Windows 8.1) is 30 minutes slow. How can I use Windows PowerShell             to move the system time up 30 minutes? Use the Set-Date cmdlet, create a TimeSpan object equal t...

Summary: Use Windows PowerShell to normalize names before importing data. Microsoft Scripting Guy, Ed Wilson, is here. I have been reading Jane Austen Northanger Abbey this week in the evenings. I really love the way Jane Austen develops her characters. I also like some of the ways the characters express themselves. For example, “Give me but ...

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

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 pot&md...