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: 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: 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: 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: 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: 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: 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: Create a Custom PowerShell Object to Simplify Appending CSV files

    Summary: Microsoft Scripting Guy, Ed Wilson, shows how to create a custom Windows PowerShell object to simplify appending to CSV files. 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...
  • Blog Post: Use PowerShell to Remove Data from CSV File

    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...
  • Blog Post: Hey, Scripting Guy! How Can I Read a CSV File?

    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...
  • Blog Post: Use PowerShell to Automatically Create a CSV File

    Summary: Learn how to use Windows PowerShell to automatically create a CSV file. Microsoft Scripting Guy Ed Wilson here. I am about finished playing around with CSV files for the time being. I do not always use the ConvertTo-CSV or the Export-CSV cmdlet. There are times that I write code and create...
  • Blog Post: Hey, Scripting Guy! How Can I Use Windows PowerShell to Sort a CSV File?

    Hey, Scripting Guy! have a comma-separated values file that includes several different fields. I’d like to be able to read this file from Windows PowerShell and then sort the information on one (or maybe more) of these fields. However, I can’t seem to get this to work. Any suggestions? -- DW Hey,...
  • Blog Post: Four Easy Ways to Import CSV Files to SQL Server with PowerShell

    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...
  • Blog Post: Use a CSV File to Populate Parameters of PowerShell Cmdlets

    Summary: Learn how to use a CSV file to populate parameters of Windows PowerShell cmdlets. Hey, Scripting Guy! I have a problem. I would like to be able to read content from a comma-separated value (CSV) file that contains a list of WMI classes and servers that I would like to query. I need to...