Parse Text Data

Break Strings into Substrings you own this product

This free project is part of the liveProject series Parse Text Data with PowerShell
intermediate PowerShell (use variables, common PowerShell built-in cmdlets, conditional and loop statements)
skills learned
read text files • use delimiter characters • basic regex • extract substrings from text • arrays and array indexes • create custom objects • add properties to objects
Fernando Corrales
1 week · 8-10 hours per week · INTERMEDIATE

placing your order...

Don't refresh or navigate away from the page.
This free project is part of the liveProject series Parse Text Data with PowerShell explore series
Check your email for instructions on accessing Break Strings into Substrings (liveProject)
continue shopping
adding to cart

Look inside

You’re a PowerShell developer working for XYZ Services Company, a consulting and outsourcing firm that recently experienced a massive failure in its IT infrastructure. While it’s working on getting the environment back up and running, you’ve been given the critical, time-sensitive task of helping avoid payroll delays. The good news is the company’s employee directory has already been extracted. The bad news is it’s been saved as plain text files, a hard-to-work-with format for payroll purposes. Applying PowerShell best practices, you’ll write scripts that parse text data and convert it into objects that are in a payroll-manageable format.

project author

Fernando Corrales
Fernando Corrales is a cloud engineer with several years of IT experience in multinational companies. He’s worked extensively with VMware products, focusing on private cloud automation with PowerCLI and PowerShell, in addition to delivering PowerShell training for some of his recent employers. Fernando holds several technical degrees from the Tecnológico de Costa Rica and has a personal blog:


This liveProject is for technology administrators and intermediate-level PowerShell users who want to learn or expand their text and string parsing skills. To begin these liveProjects you’ll need to be familiar with the following:

  • Intermediate PowerShell 7
  • Visual Studio Code with PowerShell extension
  • MS Excel or any CSV viewer
  • An HTML editor

you will learn

In this liveProject, you’ll learn techniques for parsing text with PowerShell and converting strings into PowerShell objects.

  • Use PowerShell operators to modify text strings
  • Use loops and conditional statements to sequentially process objects from a collection
  • Build a PowerShell custom object and use the Add-Member cmdlet to add properties to it
  • Export objects to CSV format, generate multiple output files, and distribute the objects based on a given condition
  • Work with simple regex expressions


You choose the schedule and decide how much time to invest as you build your project.
Project roadmap
Each project is divided into several achievable steps.
Get Help
While within the liveProject platform, get help from other participants.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.