Scripting Blog [archived]

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

CSV and other delimited files - Scripting Blog [archived]

Use PowerShell to Sort CSV Files in Order

July 11, 2013 Jul 11, 2013 07/11/13
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about sorting comma-separated value (CSV) files. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sifting through some of the email that arrives at scripter@microsoft.com. It is always fun to read the email because it gives me a great sense of what is going on with people trying ...

Create a Custom PowerShell Object to Simplify Appending CSV files

December 12, 2012 Dec 12, 2012 12/12/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, shows how to create a custom Windows PowerShell object to simplify appending to CSV files.  (image)  Hey, Scripting Guy!  Yesterday, you talked about creating two objects, exporting them to CSV files, and then manipulating the strings to combine the CSV files. Is there a cleaner way ...

Use PowerShell to Add Two Pieces of CSV Data Together

December 11, 2012 Dec 11, 2012 12/11/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about adding together two pieces of CSV information and making the rows wider, not longer. (image) Hey, Scripting Guy! I have a problem at work. Our company is in the midst of massive acquisitions and mergers. I mean every few weeks our network completely changes, and we have to absorb a new ...

Four Easy Ways to Import CSV Files to SQL Server with PowerShell

November 28, 2011 Nov 28, 2011 11/28/11
Doctor Scripto
Summary: Learn four easy ways to use Windows PowerShell to import CSV files into SQL Server. Microsoft Scripting Guy, Ed Wilson, is here.  I was chatting this week with Microsoft PowerShell MVP, Chad Miller, about the series of blogs I recently wrote about using CSV files. He thought a helpful addition to the posts would be to talk about ...

See Why PowerShell Can't Export Some Properties to CSV

November 15, 2011 Nov 15, 2011 11/15/11
Doctor Scripto
Summary: Learn why Windows PowerShell cannot export certain properties to a CSV file and what to do about it.   Microsoft Scripting Guy, Ed Wilson, is here. The other day, Terry Dow posted a comment on my Use PowerShell to Work with CSV Formatted Text blog post. Basically, Terry is asking about exporting a multivalue property via Export-...