Hi Guys,

Need a little help with regex expressions,  I am trying to only select one item from a collection, using the example below, I would only like to match "User 01 (ABC Team)":

$a = 'User 01 (ABC Team)','User 01 (ABCDE Team)','ABCUser 01 (XYZ Team)','ABCDUser 01 (X Team)','UserABCD 01 (J Team)'

$a | where {$_ -match "ABC"}
 
User 01 (ABC Team)
User 01 (ABCDE Team)
ABCUser 01 (XYZ Team)
ABCDUser 01 (X Team)
UserABCD 01 (J Team)

What do I need to specify in the match parameter, to do this?

Cheers
James

# with -match operator
PS> $a -match '\(ABC Team\)'
User 01 (ABC Team)

# using where-object and -match operator
PS > $a | where {$_ -match '(abc team)'}
User 01 (ABC Team)

# with -eq operator
PS > $a -eq 'User 01 (ABC Team)'
User 01 (ABC Team)

Cheers Shay,

What if I only want to match "ABC" on its own?

Shay,

I think I might have done it with the following:


PS C:\> $a | where {$_ -match "\s.(ABC)\s"}

User 01 (ABC Team)

I'm not sure I get the question myself, but I'll take a swing at it...

#Match any sting with ABC
PS > $a -match "ABC\s"

~Glenn

Glenn,

Just to give you some more information,

I have a large CSV file, with loads of user displaynames in it.

For example:

Brown, James (ABC Team)
Levy, Shay (Powershell dude - Team ABC)
Unknown, Glenn (Team PS)
ABCDen, Pete (Unix Team)
Black, Jane (Z&ABC Team)
Smith, Matt (North ABC)
Yellow, Nigel (South ABC)


What I want is to pick out only the following users from the above list:

Brown, James (ABC Team)
Levy, Shay (Powershell dude - Team ABC)
Smith, Matt (North ABC)
Yellow, Nigel (South ABC)

Hope this helps clear up what I am tryng to achive?

$a = "Brown, James (ABC Team)","Levy, Shay (Powershell dude - Team ABC)","Unknown, Glenn (Team PS)","ABCDen, Pete (Unix Team)","Black, Jane (Z&ABC Team)","Smith, Matt (North ABC)","Yellow, Nigel (South ABC)"

$a | where {$_ -match "\s.(abc)\s"}
Brown, James (ABC Team)

That doesn't work?

Will keep trying...

Okay, I get it now... I would use something like this,

 PS > $a -match "(\(ABC\s)|(\sABC\))"
 
~Glenn

Try this, I named the columns in the csv file as last,first:

# match '(abc' OR 'abc)' users
PS > ipcsv users.csv | where {$_.first -match '\(abc|abc\)'}

Last First
---- -----
Brown James (ABC Team)
Levy Shay (Powershell dude - Team ABC)
Smith Matt (North ABC)
Yellow Nigel (South ABC)

Cheers Guys,

Nearly there...

It is now not matching some display names like "ABC Memebers":


$a = "Brown, James (ABC Team)","Levy, Shay (Powershell dude - Team ABC)","Unknown, Glenn (Team PS)","ABCDen, Pete (Unix Team)","Black, Jane (Z&ABC Team)","Smith, Matt (North ABC)","Yellow, Nigel (South ABC)","Team ABC Meeting","ABC Members"

PS C:\> $a
Brown, James (ABC Team)
Levy, Shay (Powershell dude - Team ABC)
Unknown, Glenn (Team PS)
ABCDen, Pete (Unix Team)
Black, Jane (Z&ABC Team)
Smith, Matt (North ABC)
Yellow, Nigel (South ABC)
Team ABC Meeting
ABC Members


Cheers
James

PS C:\> $a | where {$_ -match "(\(ABC)\s|(\sABC\))"}
Brown, James (ABC Team)
Levy, Shay (Powershell dude - Team ABC)
Smith, Matt (North ABC)
Yellow, Nigel (South ABC)

The regex patter may very depending on your needs, here's one way:

PS > $a -match '\(abc|abc\)|abc members'

Brown, James (ABC Team)
Levy, Shay (Powershell dude - Team ABC)
Smith, Matt (North ABC)
Yellow, Nigel (South ABC)
ABC Members

okay...
Match any string that starts with abc, or contains abc, or contains (ABC, or contains ABC)

PS > $a -match "^ABC\s|\sABC\s|(\(ABC\s)|(\sABC\))"

~Glenn

Thanks both very much for your help...

The following parameter from Glenn, does the job:

$a -match "^ABC\s|\sABC\s|(\(ABC\s)|(\sABC\))"

I am learning new things every day :-)

Cheers again.
James