Author Posts

August 30, 2017 at 7:49 am

Hi everyone!

I have a CSV file containing multiple lines which look like this: Image (Editor can't display the code the way I need to)
How do I get only the values from this CSV file?
My goal is to store all these values in an array...
This is what I got so far:

$importPath = "temp.csv"
$pattern =

$string = Get-Content $importPath
$result = [regex]::match($string, $pattern).Groups[1].Value

This only returns one time the value all the other value1, value2, value n their values get ignored...

August 30, 2017 at 4:01 pm

You can use Import-CSV to import csv's as a PSObject:

$importPath = "temp.csv"
$csv = Import-CSV -Path $importPath