Powershell Regex match statement

Question

Trying to get nxxxxx number as the output from below input,

uniqueMember: uid=n039833,ou=people,ou=networks,o=test,c=us
uniqueMember: uid=N019560, ou=people, ou=Networks, o=test, c=Us

Tried,

[Regex]::Matches($item, "uid=([^%]+)\,")

but this gives,

Groups   : {0, 1}
Success  : True
Name     : 0
Captures : {0}
Index    : 14
Length   : 43
Value    : uid=N018315,ou=people,ou=Networks,o=test,

Success  : True
Name     : 1
Captures : {1}
Index    : 18
Length   : 38
Value    : N018315,ou=people,ou=Networks,o=test

Some help with improving the match statement appreciated ..

You can ignore matching a comma uid=([^%,]+), and get the capture group 1 value regex101.com/r/VEi4M1/1 — The fourth bird
– The fourth bird, Commented May 13, 2022 at 16:40

Wiktor Stribiżew · Accepted Answer · 2022-05-13 20:43:29Z

3

You can use

[Regex]::Matches($s, "(?<=uid=)[^,]+").Value

To save in an object variable:

$matches = [Regex]::Matches($s, "(?<=uid=)[^,]+").Value

Output:

n039833
N019560

Details:

(?<=uid=) - a positive lookbehind that requires uid= text to appear immediately to the left of the current location
[^,]+ - one or more chars other than a comma.

edited May 13, 2022 at 20:43

answered May 13, 2022 at 16:56

Wiktor Stribiżew

631k41 gold badges502 silver badges633 bronze badges

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

1 Comment

Santiago Squarzon Over a year ago

you can use [Regex]::Matches( ).Value, powershell can do the enumeration of the property values for you

The fourth bird · Accepted Answer · 2022-05-13 17:06:21Z

2

You can use a capture group and prevent matching , and if you don't want to match % you can also exclude that.

$s = "uniqueMember: uid=n039833,ou=people,ou=networks,o=test,c=us\nuniqueMember: uid=N019560, ou=people, ou=Networks, o=test, c=Us"
[regex]::Matches($s,'uid=([^,]+)') | Foreach-Object {$_.Groups[1].Value}

Output

n039833
N019560

Note that in the current pattern there should be a trailing comma present. If that is not ways the case, you can omit matching that from the pattern. If you only want to exclude matching a comma, the pattern will be:

uid=([^,]+)

edited May 13, 2022 at 17:06

answered May 13, 2022 at 16:58

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

1 Comment

Sean21735 Over a year ago

Thanks everyone for the help, was trying to format .ldif from Unix team to import to AD, DN is diff between systems ..

Collectives™ on Stack Overflow

Powershell Regex match statement

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related