PowerShell sort CSV with multiple items

Question

I am unable to sort a CSV properly. I have data in the following format:

File.csv:

Name,Application
user1,app1
user1,app1
user2,app1
user2,app2

...

I am able to get a list of users with more than one app1, more than one app2, but I cannot figure out how to get a list of users with app1 AND app2.

    $users = Import-Csv file.csv
    $users | ? {$_.Application -eq "app1" | Group Name | ? {$_.Count -gt 1} |
 % {$_ | select -ExpandProperty group | select -first 1}

    $users | ? {$_.Application -eq "app2" | Group Name | ? {$_.Count -gt 1} |
 % {$_ | select -ExpandProperty group | select -first 1}

I'm not even sure on where to start for combining the two.

Mathias R. Jessen · Accepted Answer · 2015-05-18 15:31:02Z

2

Group by user name and check that each group contains an entry for each application:

$UsersWithBothApps = $users | Group-Object -Property Name | ForEach-Object {
    $Apps = $_.Group | Select-Object -ExpandProperty Application
    if($Apps -contains "app1" -and $Apps -contains "app2"){
        $_.Name
    }
}

answered May 18, 2015 at 15:31

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Comments

user4018458 · Accepted Answer · 2015-05-20 05:13:34Z

0

Another approach:

#requires v4.0
$app1='app1'
$app2='app2'

$users | 
    group name | 
    ?{ $_.group.application -eq $app1 } |
    ?{ $_.group.application -eq $app2 } |
    % name

answered May 20, 2015 at 5:13

user4018458

Collectives™ on Stack Overflow

PowerShell sort CSV with multiple items

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related