Scripting Blog [archived]

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

CSV and other delimited files - Scripting Blog [archived]

Hey, Scripting Guy! Weekend Scripter: Uniquifying and Validating Link Lists with Windows PowerShell

July 17, 2010 Jul 17, 2010 07/17/10
ScriptingGuy1
  Microsoft Scripting Guy Ed Wilson here. It is a beautiful Saturday morning here in Charlotte, North Carolina, in the United States. The sky is dark blue and there are few if any clouds visible. It almost makes one dizzy while standing in the front yard leaning back and looking upward because there is nothing to give any frame of ...

Hey, Scripting Guy! How Can I Convert a Tab-Delimited File to a Comma-Separated Value File?

April 14, 2009 Apr 14, 2009 04/14/09
ScriptingGuy1
(image) Hey, Scripting Guy! I have this tab-delimited file that was produced by a report from an old database application. All it knows how to do is make a tab-delimited file. I hate this format, and our other applications do too. I have been opening the thing in Notepad and trying to find and replace tabs with commas, but Notepad does not ...

Hey, Scripting Guy! How Can I Create Users from a CSV File?

October 20, 2008 Oct 20, 2008 10/20/08
ScriptingGuy1
(image) Hey, Scripting Guy! In your last article, you showed how to create random passwords for users and how to write that password out to a CSV file. You said if anyone asked that you would show how to use that CSV file and create a user from it. Well, here I am, asking you. Show me the script. I'll send chocolate.- LZ(image) (image) Hi ...

Hey, Scripting Guy! How Can I Read a CSV File?

October 13, 2008 Oct 13, 2008 10/13/08
ScriptingGuy1
(image) Hey, Scripting Guy! I am new to scripting, but I have been tasked with creating a script anyway. What I need to do is to read in a CSV file and then perform an operation on each line in the file. I do not know what the correct cmdlet is or what action I need to use. Can you point me in the right direction?- DF(image) (image) Hi DF...