Welcome to the Forum and the world of PowerShell. Here are a couple of examples for you to test and digest. Please don't hesitate to ask follow-up questions to understand below better and use Get-Help for additional details.

Usually, I would import the CSV from disk with the Import-Csv cmdlet. The block of code line 1 to 12 is only a hack to get the example CSV you've posted into a useable state without creating a file on my machine. The resulting array of objects is the same as using Import-Csv for a file on disk.

Import-Csv does a bit of magic. It imports a CSV file and outputs an array of objects with properties for each header column in your file instead of lines of plain-text like Get-Content. That makes handling the content easier for processing. If your CSV file would come without a header you could specify a custom header with the -Header parameter but for your example CSV that is not necessary.

You could pipe the output of Import-Csv but the code would look slightly different.

Additionally, you might want to pick up the book "Learn Windows PowerShell in a Month of Lunches" or watch the "Getting Started with PowerShell" series on Channel 9 (https://channel9.msdn.com) or the Microsoft Virtual Academy (https://mva.microsoft.com). Both the book and the video series cover PowerShell basics very well.