Powershell to get the required substring from a string

Question

I have a string which looks something like this:

"Comments : @{id=15161772,we are happy with the service,likes=&÷€$:#,hsbdinsjsonsjbdjdjid}"

I would like to get the part "We are happy with the service".

I have tried something like:

$string ="Comments : @{id=15161772,we are happy with the service,likes=&÷€$:#,hsbdinsjsonsjbdjdjid}"
$string.split(",") | foreach {if(($_ -Notlike "*id=*" ) -and ($_ -Notlike "*likes=*")){$_ }}

I get the result as:

We are happy with the service
hsbdinsjsonsjbdjdjid

I wish to only get "we are happy with the service".

Jan Chrbolka · Accepted Answer · 2015-04-09 03:13:00Z

1

If you can guarantee that the item you are looking for does not contain commas, then you are simply looking at second element in a comma delimitered string.

$string.split(",")[1]

answered Apr 9, 2015 at 3:13

Jan Chrbolka

4,4842 gold badges31 silver badges38 bronze badges

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

Comments

TheMadTechnician · Accepted Answer · 2015-04-09 03:48:43Z

1

I'll go for the RegEx option...

$string ='Comments : @{id=15161772,we are happy with the service,likes=&÷€$:#,hsbdinsjsonsjbdjdjid}'
$string -replace ".*?=.*?,(.*?),likes=.*", "`$1"

That outputs your desired text, and should return out everything after the first equals sign, and before ,likes=. If you want to capture it, just assign it to a variable, such as:

$Comment = $string -replace ".*?=.*?,(.*?),likes=.*", "`$1"

Then $Comment will contain the string we are happy with the service.

This should be more flexible than splitting on the comma. See examples and more details on how the RegEx works at: https://regex101.com/r/fK1oX6/1

answered Apr 9, 2015 at 3:48

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

Comments

mjolinor · Accepted Answer · 2015-04-09 10:24:06Z

1

Using a regex split:

$string = 'Comments : @{id=15161772,we are happy with the service,likes=&÷€$:#,hsbdinsjsonsjbdjdjid}'
($string -split 'id=\d+,|,likes=')[1]
we are happy with the service

answered Apr 9, 2015 at 10:24

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

Powershell to get the required substring from a string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related