Powershell Regex Query

Question

I'm having some issues pulling the desired values from my source string.

I have 2 possible string formats (that I'm differentiating based on a -match operation and if check):

{u'specialGroup': u'projectWriters', u'role': u'WRITER'

or

, {u'role': u'WRITER', u'userByEmail': u'[email protected]'

What I desire to return from the regex:

[0]projectWriters

[1]WRITER

and

[0]WRITER

[1][email protected]

Basically I need to return all values between start string : u' and end string ' as array values [0] and [1] but cannot figure out the regex pattern.

Trying:

[regex]::match($stuff[1], ": u'([^']+)'").groups

Groups   : {: u'WRITER', WRITER}    
Success  : True
Captures : {: u'WRITER'}
Index    : 10
Length   : 11
Value    : : u'WRITER'



Success  : True
Captures : {WRITER}
Index    : 14
Length   : 6
Value    : WRITER

But no sign of [email protected] value.

mklement0 · Accepted Answer · 2017-05-11 16:14:42Z

1

A pragmatic approach, assuming that all strings have the same field structure:

$strings = "{u'specialGroup': u'projectWriters', u'role': u'WRITER'}",
           ", {u'role': u'WRITER', u'userByEmail': u'[email protected]'"

$strings | ForEach-Object { ($_ -split 'u''|''' -notmatch '[{}:,]')[1,3] }

yields:

projectWriters
WRITER
WRITER
[email protected]

As for what you tried:

[regex]::match() only ever returns one match, so you need to base your solution on [regex]::matches() - plural! - which returns all matches, and then extract the capture-group values of interest.

$strings | ForEach-Object { [regex]::matches($_, ": u'([^']+)'").Groups[1,3].Value }

edited May 11, 2017 at 16:14

answered May 11, 2017 at 15:49

mklement0

452k68 gold badges727 silver badges986 bronze badges

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

Collectives™ on Stack Overflow

Powershell Regex Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related