Powershell : ForEach Loop

Question

How to edits the questions is like to be ask by someone

Mathias R. Jessen · Accepted Answer · 2017-05-30 09:32:39Z

3

You can use Export-Csv for this.

First, you'll want to create objects rather than strings from the two arrays:

$objects = foreach($f1 in $file1)
{
    foreach($f2 in $file2)
    {
        New-Object psobject -Property @{
            Server = $f1
            HotfixID = $f2
        }
    }
}

Now we can pipe these to Export-Csv and specify a delimiter (a space in your case):

$objects |Export-Csv -Path "C:\path\to\output.file" -Delimiter ' ' -NoTypeInformation

edited May 30, 2017 at 9:32

answered May 30, 2017 at 6:23

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Atul D Over a year ago

Thank you so much for your help :)

Jeff Zeitlin · Accepted Answer · 2017-05-30 06:31:18Z

2

You've fallen into the same trap as many others when working with PowerShell - you're manipulating text instead of objects.

Instead of concatenating strings ({$f1+","+$f2}), create an object:

{ New-Object PSObject -Property @{ "Server" = $f1; "Hotfix" = $f2 } }

Then, wrap the whole ForEach in parentheses, and assign to a variable:

$hfdata = ( ForEach ... )

...and finally, Export-CSV the array:

Export-CSV -InputObject $hfdata -Path $savefile

answered May 30, 2017 at 6:31

Jeff Zeitlin

11k2 gold badges26 silver badges38 bronze badges

Collectives™ on Stack Overflow

Powershell : ForEach Loop

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related