Ask Your Question
0

How can the CSV be iterated through using a ForEach loop?

asked 2021-09-01 11:00:00 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2022-03-26 00:00:00 +0000

pufferfish gravatar image

To iterate through a CSV using a ForEach loop, you will need to first read the CSV data into an array, and then use a ForEach loop to iterate through each row in the array.

Here's an example code snippet in PowerShell:

$csvData = Import-Csv -Path "C:\Users\example\Documents\data.csv"

ForEach ($row in $csvData) {
    # Access each field in the row by referencing its header name
    Write-Host "Name: $($row.Name), Age: $($row.Age), Email: $($row.Email)"
}

In this example, we're using PowerShell's Import-Csv cmdlet to read the data from a CSV file and store it in the $csvData array. Then, we use a ForEach loop to iterate through each row in the array ($row) and access its fields using their header names ($row.Name, $row.Age, and $row.Email).

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-09-01 11:00:00 +0000

Seen: 7 times

Last updated: Mar 26 '22