Scripting Blog [archived]

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

CSV and other delimited files - Scripting Blog [archived]

PowerShell Mini-Scripting Games 2014: Answer 1

August 18, 2014 Aug 18, 2014 08/18/14
Doctor Scripto
Summary: Here is the answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Here is an answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Last week, I posted the complete Problem 1 description and task outline. Problem one synopsis You are reading a CSV file that was ...

Use PowerShell to Create CSV File to Open in Excel

February 4, 2014 Feb 4, 2014 02/4/14
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about exporting a directory list to a CSV file and opening the file in Microsoft Excel with Windows PowerShell. (image)  Hey, Scripting Guy! I have a lot of music files that reside in nested folders. I would like to be able to look at the file information in Microsoft Excel so that I can ...

Use PowerShell to Remove Data from CSV File

November 21, 2013 Nov 21, 2013 11/21/13
Doctor Scripto
Summary: Guest blogger, Matt Tisdale, talks about using Windows PowerShell to remove data from a .csv file. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Matt Tisdale… Last night a geoscientist told me that he has almost 900 .csv files, and he needs to remove two columns of data from them. He has used Windows ...

Write Users and Proxy Addresses to CSV by Using PowerShell

July 23, 2013 Jul 23, 2013 07/23/13
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about writing all proxy addresses and user names to a CSV file by using Windows PowerShell. (image)  Hey, Scripting Guy! Yesterday’s blog post, Export User Names and Proxy Addresses to CSV File, showed me an easy way to get a couple of proxy addresses from Active Directory, but all ...

Export User Names and Proxy Addresses to CSV File

July 22, 2013 Jul 22, 2013 07/22/13
Doctor Scripto
Summary: Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell to export user names and proxy addresses to a CSV file from Active Directory. (image)  Hey, Scripting Guy! I am trying to produce a report of our users in Active Directory and their associated proxy addresses. I want it in Excel, so I am using the Export-CSV ...