Browse by Tags

Tagged Content List
  • Blog Post: Use PowerShell to Read Munged Data

    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...
  • Blog Post: PowerShell Mini-Scripting Games 2014: Answer 2

    Summary : Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline . Problem...
  • Blog Post: PowerShell Mini-Scripting Games 2014: Answer 1

    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...
  • Blog Post: Use PowerShell to Create CSV File to Open in Excel

    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. 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...
  • Blog Post: Hey, Scripting Guy! How Can I Convert a Tab-Delimited File to a Comma-Separated Value File?

    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...
  • Blog Post: Use PowerShell to Work with Any INI File

    Summary : Guest Blogger Oliver Lipkau shares two Windows PowerShell functions to simplify reading and writing to INI files. Microsoft Scripting Guy Ed Wilson here. Today, we have another guest blog post, this one written by Oliver Lipkau. Oliver has written a guest blog post before , and he was...
  • Blog Post: 2012 Scripting Games Advanced Event 6: Compute Uptime for Multiple Servers

    Summary : In Advanced Event 6, you are required to compute the uptime for multiple servers. About this event Division Advanced Date of Event 4/9/2012 12:01 AM Due Date 4/16/2012 12:01 AM Event scenario You are...
  • Blog Post: How Can I Create a CSV File?

    Hey, Scripting Guy! How can I create a CSV file? -- LF Hey, LF. For those of you who aren’t up on your acronyms, CSV is short for comma-separated-values file, a text file in which individual elements are separated by commas. For example, say you have a CSV file consisting of user first names, last...
  • Blog Post: Learn How to Manually Create a CSV File in PowerShell

    Summary : The Scripting Wife learns how to manually create a CSV file in this beginner Windows PowerShell blog. Microsoft Scripting Guy, Ed Wilson, is here. Ah, it is the weekend. It seems that this week has been rather long, although I know that is a misconception because each week only has 168 hours...
  • Blog Post: Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (05/01/09)

    How Can I Get Help with Scripts I’m Writing? Hey, Scripting Guy! I am a novice scripter but am being diligent about learning more specifically around VBScript. I am following the Microsoft Press book, Windows Scripting Self-Paced Learning Guide , and I find it very helpful. Is there someplace people...
  • Blog Post: How Can I Copy Selected Columns From a CSV File to an Excel File?

    Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file? -- MdP Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum. Some of you might be concerned...
  • Blog Post: Use PowerShell to Add Two Pieces of CSV Data Together

    Summary: Microsoft Scripting Guy, Ed Wilson, talks about adding together two pieces of CSV information and making the rows wider, not longer. 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...
  • Blog Post: Hey, Scripting Guy! Weekend Scripter: Uniquifying and Validating Link Lists with Windows PowerShell

    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...
  • Blog Post: Convert a Semicolon-Delimited File to a CSV File

    Summary: Learn how to convert easily a semicolon delimited file into a CSV file using Windows PowerShell. Hey, Scripting Guy! I have a problem at work, and I hope you can help. We have an application that writes one log file every four hours. These log files are formatted with semicolons, which...
  • Blog Post: How Can I Parse a Tab-Delimited File and Then Save That as a Comma-Separated Values File?

    Hey, Scripting Guy! How can I parse a tab-delimited file, and then save the resulting information as a comma-separated values file? -- DM Hey, DM. You know, yesterday morning the Scripting Guy who writes this column had to scrape the ice off his windshield; today it’s much warmer – 44 at last report...
  • Blog Post: Search for and Replace Words in a CSV File by Using PowerShell

    Summary: Learn how to search for and replace words in a CSV file by using Windows PowerShell. Hey, Scripting Guy! I have a comma-separated value (CSV) file that contains user names, user groups, and organizational unit (OU) assignments. The problem is that we are moving one of our office locations...
  • Blog Post: The 2011 Scripting Games Advanced Event 7: Map User's Names and Twitter Names with PowerShell

    Summary : Advanced Event 7 in 2011 Scripting Games uses Windows PowerShell to map user's names to Twitter names. About this event Division Advanced Date of Event 4/12/2011 12:15 AM Due Date 4/19/2011 12:15 AM Event...
  • Blog Post: Export User Names and Proxy Addresses to CSV File

    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. 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...
  • Blog Post: See Why PowerShell Can't Export Some Properties to CSV

    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...
  • Blog Post: Easily Remove Columns from a CSV File by Using PowerShell

    Summary: Use a super simple, one-line command to remove columns easily from a CSV file using Windows PowerShell. Hey, Scripting Guy! I have a CSV file from which I need only two of eight columns. Can Windows PowerShell delete certain columns? I have searched the Internet for days with no luck....
  • Blog Post: Hey, Scripting Guy! How Can I Prevent Office Excel From Turning My Imported Numbers Into Dates?

    Hey, Scripting Guy! I have a CSV file, and every time I open that file in Office Excel my numbers get converted to dates. How can I import numbers as numbers? -- JR Hey, JR. You know, just yesterday the Scripting Guy who writes this column learned about Yelo , an interesting little company based...
  • Blog Post: Hey, Scripting Guy! How Can I Modify a .CSV File and Then Import That File into Microsoft Excel?

    Hey, Scripting Guy! I have a comma-separated values file that I need to import into Excel. However, before I do that I need to do some arithmetic and then add an additional field to the CSV file. On top of that, when I import this file I need to format this new field as a date-time value. How can I do...
  • Blog Post: Use PowerShell to Work with CSV Formatted Text

    Summary : See how to use Windows PowerShell to create CSV files from formatted and unformatted text. Hey, Scripting Guy! I have begun to play around with Windows PowerShell, and it is absolutely the most confusing thing Microsoft has ever created. Simple things are easy. I can use Get-Process and...
  • Blog Post: Write Users and Proxy Addresses to CSV by Using PowerShell

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about writing all proxy addresses and user names to a CSV file by using Windows PowerShell. 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...
  • Blog Post: How Can I Parse a Comma-Separated Values File?

    Hey, Scripting Guy! I have a text file which consists of individual fields separated by commas. I need to look at the second field in each line and, if it includes the word Everyone , I then need to take the sixth field in the line and write that value to a second text file. How can I do that? -- RP...