Scripting Blog

A place to learn about PowerShell and share stories of automation

November 2011 - Page 6 of 6 - Scripting Blog

Use PowerShell to Read CSV Files and Create Files and Folders

November 5, 2011 Nov 5, 2011 11/5/11
Doctor Scripto
Summary: Learn how to use Windows PowerShell to read CSV files and create files and folders.   Microsoft Scripting Guy Ed Wilson here. This past week has been fun. I enjoy talking about comma-separated value files (CSV) because they are very flexible, and Windows PowerShell makes working with them really easy. One of the cool things that...

Use a CSV File to Populate Parameters of PowerShell Cmdlets

November 4, 2011 Nov 4, 2011 11/4/11
Doctor Scripto
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 be able to read the CSV file, and based ...

Search for and Replace Words in a CSV File by Using PowerShell

November 3, 2011 Nov 3, 2011 11/3/11
Doctor Scripto
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, and I need to quickly change the old ...

Remove Unwanted Quotation Marks from CSV Files by Using PowerShell

November 2, 2011 Nov 2, 2011 11/2/11
Doctor Scripto
Summary: Learn how to remove unwanted quotation marks from a CSV file by using Windows PowerShell.   Microsoft Scripting Guy Ed Wilson here. The fall is rapidly falling down here in Charlotte, North Carolina, in the United States. It is cooling off here, and is around 60 degrees Fahrenheit (15.5 degrees Celsius, according to my conversion...

Use PowerShell to Remove Duplicate Lines from a CSV File

November 1, 2011 Nov 1, 2011 11/1/11
Doctor Scripto
Summary: Learn how to use Windows PowerShell to easily remove duplicates from a CSV file.   Hey, Scripting Guy! I have a comma-separated value (CSV) file that comes from a Microsoft Excel spreadsheet. We use this CSV file to create new users automatically in Active Directory. The problem is that every once in a while, duplicates end up in...