Parse Text Data

Report from Multiple Text Files you own this product

This project is part of the liveProject series Parse Text Data with PowerShell
prerequisites
intermediate PowerShell (use variables, common PowerShell built-in cmdlets, loop statements)
skills learned
work with objects with FileInfo type • use the switch statement and its File parameter to process multiple text files • create custom objects • add properties to objects • use methods to modify text strings • export objects to CSV format
Fernando Corrales
1 week · 4-6 hours per week · INTERMEDIATE

placing your order...

Don't refresh or navigate away from the page.
liveProject This project is part of the liveProject series Parse Text Data with PowerShell liveProjects give you the opportunity to learn new skills by completing real-world challenges in your local development environment. Solve practical problems, write working code, and analyze real data—with liveProject, you learn by doing. These self-paced projects also come with full liveBook access to select books for 90 days plus permanent access to other select Manning products. $19.99 $29.99 you save $10 (33%)
Report from Multiple Text Files (liveProject) added to cart
continue shopping
adding to cart

Look inside

XYZ Services Company, the consulting and outsourcing firm you work for, is getting up and running after a massive IT infrastructure failure. In the meantime, the Human Resources department would like a report with basic staff data that it will use to distribute payslips to employees. As a PowerShell developer, you’ll use the switch statement and its file parameter to read and extract information from the source files provided by the company’s Active Directory before the system failed, build PowerShell objects, and export them into CSV format—helping HR provide proof of payment and putting your coworkers’ minds at ease.

This project is designed for learning purposes and is not a complete, production-ready application or solution.

book resources

When you start your liveProject, you get full access to the following books for 90 days.

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: fercorrales.com.

prerequisites

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:

TOOLS
  • Intermediate PowerShell 7
  • Visual Studio Code with PowerShell extension
  • you will learn

    In this liveProject, you’ll learn how to use the switch statement and its file parameter to read and extract information from source files, build PowerShell objects, and export them into CSV format.

    • Use simple regular expressions and the match operator to find strings that match a given pattern
    • Use the foreach statement to sequentially process objects from a collection
    • Work with the Length property of the objects with System.String type
    • Use the IndexOf and Substring methods to select substrings from a text string
    • Use the Trim method to remove unwanted characters from a string
    • Build an object using the PSCustomObject type accelerator
    • Add properties to an existing custom object using the Add-Member cmdlet
    • Export objects to a CSV file to generate a report
    • Display objects on the screen

    features

    Self-paced
    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 and our expert mentors.
    Compare with others
    For each step, compare your deliverable to the solutions by the author and other participants.
    book resources
    Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.
    RECENTLY VIEWED