Скачать или смотреть How to Delete or Skip Columns in CSV Files using PowerShell

Learn how to easily manipulate CSV files with PowerShell, including deleting unnecessary columns and assigning new headers.
---
This video is based on the question https://stackoverflow.com/q/63884670/ asked by the user 'SikorskyS60' ( https://stackoverflow.com/u/14274908/ ) and on the answer https://stackoverflow.com/a/63885265/ provided by the user 'Steven' ( https://stackoverflow.com/u/4749264/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: PowerShell Delete or Skip Columns in CSV

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Delete or Skip Columns in CSV Files using PowerShell

As a PowerShell rookie, it's natural to feel overwhelmed by the various tasks you can perform with it, especially when dealing with CSV files. If you're dealing with an unusual CSV format that has headers in every row—a format that's not conducive for straightforward data manipulation—you might find yourself wondering how to delete specific columns and assign new headers. In this guide, we’ll break down the process in clear terms and give you a solution that you can implement right away!

Understanding the Problem

Imagine you have a CSV file that looks like this:

[[See Video to Reveal this Text or Code Snippet]]

Every row contains redundant header information, and you want to keep only specific data (in this case, the Name and Lastname) while discarding the Example1 and Example2 columns. Additionally, you'd like to assign new headers like Name, Lastname, Address, and Phone.

The Solution

To tackle this, we can write a PowerShell script that reads the CSV file, processes the data to remove unwanted columns, and assigns new headers. Below is a step-by-step explanation and the corresponding code for the task.

Step-by-Step Approach

Read the CSV: First, we use the Get-Content cmdlet to read the file contents. We will process each line individually.

Split the Data: Use the Split() method to break each line into an array of values. This allows us to access specific columns easily.

Create a Hash Table: For each entry, we'll create an ordered hash table to map the specific columns we want to keep with their corresponding values.

Convert to Custom Object: Transform the hash table into a PowerShell custom object so it can be exported as a clean CSV.

Export the Data: Finally, use Export-CSV to save the new data to a fresh CSV file.

The PowerShell Code

Here’s a basic example of how you might write this in PowerShell:

[[See Video to Reveal this Text or Code Snippet]]

Excluding Unwanted Columns

If you want to specifically exclude the Example1 and Example2 columns from your result, you can enhance the script like this:

[[See Video to Reveal this Text or Code Snippet]]

Benefits of the Approach

Efficiency: This method allows you to iterate through each line quickly and efficiently filter out unwanted data.

Customizability: By adjusting the content of the excludes array or modifying headers post-processing, you can tailor this script to fit various project needs.

Final Thoughts

Manipulating CSV files using PowerShell may seem daunting at first, but with the right approach, it becomes a straightforward task. By understanding what each part of the script does, you can easily adjust it as required. As you grow more accustomed to PowerShell, you'll find it to be a powerful tool for data manipulation and automation.

We hope this guide helps you in your initial steps with PowerShell! Happy scripting!