powershell: separate and parse multiline string

Question

I have been having trouble parsing an output from a rest api. it is a Multiline string

Policy Name: Default_US_MultiSite Id: abc1234abc123 Buckets: support_us1_multisite,ch1ny2
Policy Name: Default_CH Id: 123456789acdef Buckets: question,answer,ch2,ch1,drive.me.closer
Policy Name: Default_NY Id: qrstuvwxyz9876 Buckets: demo,bucket1,test1,test,ny0,nyhello,goodbye,new.shoes,pizza,cutecats,theinternetisfor,Halloween,For-the-emperor

Now I do have an idea on how to split it by line, kinda and I try to use the following code

$data.Split("`n")

but I still cant figure out how to go about next and parse this

it doesnt recognize Policy Name, buckets, id as separate objects

do I convert it into or assign it as json or xml or something using more than just Convertto-xml or [xml] prefixing $data?

Thanks

Bill_Stewart · Accepted Answer · 2017-02-16 15:19:40Z

7

Example:

$data = @"
Policy Name: Default_US_MultiSite Id: abc1234abc123 Buckets: support_us1_multisite,ch1ny2
Policy Name: Default_CH Id: 123456789acdef Buckets: question,answer,ch2,ch1,drive.me.closer
Policy Name: Default_NY Id: qrstuvwxyz9876 Buckets: demo,bucket1,test1,test,ny0,nyhello,goodbye,new.shoes,pizza,cutecats,theinternetisfor,Halloween,For-the-emperor
"@

$data -split "`n" |
  Select-String 'Policy Name: (\w+) Id: (\w+) Buckets: (.+)' |
  ForEach-Object {
  New-Object PSObject -Property ([Ordered] @{
    "PolicyName" = $_.Matches[0].Groups[1].Value
    "Id"         = $_.Matches[0].Groups[2].Value
    "Buckets"    = $_.Matches[0].Groups[3].Value
  })
}

Select-String outputs MatchInfo objects. From these you can extract the match groups. New-Object outputs a new object based on the matches extracted from each output string.

edited Feb 16, 2017 at 15:19

answered Feb 15, 2017 at 23:06

Bill_Stewart

24.9k5 gold badges55 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

powershell: separate and parse multiline string

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