Regex to matching strings Powershell

Question

I am trying regex to match the names in the string below:

$strText = "some text, 'Frances , David', some text, 'Foljevic, Laura M', some text, Holjevic, Louis, some text, 'Staples, Cheri L', some text"

The name must start and end with single quotation mark(') There can be optional space before and after comma sign(,) There can be first, last and middle name.

I am trying to match with the following pattern: '\w*(\s*)?, \w*(\s*\w*)?' but it fails in case of middle name.

mjolinor · Accepted Answer · 2015-01-07 14:58:56Z

2

Like this?

 $strText = "some text, 'Frances , David', some text, 'Foljevic, Laura M', some text, Holjevic, Louis, some text, 'Staples, Cheri L', some text"

    $result = 
    [regex]::Matches($strText,"'(.+?)'") |
    foreach {$_.groups[1].value}

    $result

    Frances , David
    Foljevic, Laura M
    Staples, Cheri L

edited Jan 7, 2015 at 14:58

answered Jan 7, 2015 at 14:04

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

1 Comment

user3835927 Over a year ago

Hi mjolinor, Can i add output strings to some collection like $Result = @()?

Collectives™ on Stack Overflow

Regex to matching strings Powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related