Browse by Tags

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...

Published Wed, Dec 12 2012 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

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...

Published Tue, Dec 12 2012 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

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...

Published Sat, Mar 03 2012 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, Weekend Scripter, Scripting Wife, CSV and other delimited files, 2012 Scripting Games

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...

Published Mon, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, databases, guest blogger, SQL Server, CSV and other delimited files, Chad Miller

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...

Published Tue, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, XML, CSV and other delimited files

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...

Published Sun, Nov 11 2011 1:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, Weekend Scripter, CSV and other delimited files

Use PowerShell to Read CSV Files and Create Files and Folders

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...

Published Sat, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, Weekend Scripter, CSV and other delimited files

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...

Published Fri, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, WMI, CSV and other delimited files

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...

Published Thu, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, text files, CSV and other delimited files

Remove Unwanted Quotation Marks from CSV Files by Using PowerShell

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...

Published Wed, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

Use PowerShell to Remove Duplicate Lines from a CSV File

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...

Published Tue, Nov 11 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

Use PowerShell to Append CSV Files Easily

Summary: Learn how to use Windows PowerShell to easily append one CSV file to another CSV file. Hey, Scripting Guy! I have a problem, and I have searched everywhere on the Internet to find an answer. I need to be able to append one comma separated value...

Published Mon, Oct 10 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

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...

Published Tue, Oct 10 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

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...

Published Mon, Oct 10 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

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...

Published Fri, Sep 09 2011 2:01 AM by Hey, Scripting Guy! Blog : Windows PowerShell

Filed under: Scripting Guy!, Windows PowerShell, scripting techniques, CSV and other delimited files

Recent Posts

Archives

Tags

Create a Custom PowerShell Object to Simplify Appending CSV files

Use PowerShell to Add Two Pieces of CSV Data Together

Learn How to Manually Create a CSV File in PowerShell

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

See Why PowerShell Can't Export Some Properties to CSV

Use PowerShell to Automatically Create a CSV File

Use PowerShell to Read CSV Files and Create Files and Folders

Use a CSV File to Populate Parameters of PowerShell Cmdlets

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

Remove Unwanted Quotation Marks from CSV Files by Using PowerShell

Use PowerShell to Remove Duplicate Lines from a CSV File

Use PowerShell to Append CSV Files Easily

Convert a Semicolon-Delimited File to a CSV File

Easily Remove Columns from a CSV File by Using PowerShell

Use PowerShell to Work with CSV Formatted Text