PowerShell by Patrik

Read Row by Row in a Loop from a CSV File using PowerShell

Assuming a CSV file as such:

 Name, Address, City
name1, Address1, city1
name2, Address2, city2
name3, Address3, city3

We will use Import-Csv to populate the objects from a CSV file. With $csv.Name we will retrieve all cells in the Name column and pass this to the ForEach-Object cmdlet to loop through each item. In this loop, we will just output the name.

 $csv = Import-Csv "C:\File.csv"
$csv.Name | ForEach-Object {
    Write-Output "The name is: $_"
}

PowerShell

Referenced in:

Add to your own Set Add

Comments

About - Privacy - Contact

Add your own Set.

Twitter
Facebook
Linkedin
Email

Share
Add to Set
Open

Successfully added

Read Row by Row in a Loop from a CSV File using PowerShell

Comments

Add to Set

Share '' on

Actions

	Name, Address, City
	name1, Address1, city1
	name2, Address2, city2
	name3, Address3, city3

	$csv = Import-Csv "C:\File.csv"
	$csv.Name \| ForEach-Object {
	Write-Output "The name is: $_"
	}