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

Aug 26, 2014
0
0

PowerTip: Create Custom Names for CSV File

Doctor Scripto
Doctor Scripto

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

Scripting Guy!Windows PowerShellPowerTip
Aug 26, 2014
0
0

Use PowerShell to Fix Date from CSV File

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

Scripting Guy!Windows PowerShellscripting techniques
Aug 25, 2014
0
0

PowerTip: Use PowerShell to Read Tab Delimited File

Doctor Scripto
Doctor Scripto

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

Scripting Guy!Windows PowerShellPowerTip
Aug 25, 2014
0
0

Use PowerShell to Read Munged Data

Doctor Scripto
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 spea...

Scripting Guy!Windows PowerShellscripting techniques
Aug 24, 2014
0
0

PowerTip: Find Cmdlets that Need TimeSpan Object

Doctor Scripto
Doctor Scripto

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

Scripting Guy!Windows PowerShellPowerTip