Trim or replace PowerShell string variable

Question

I have a string variable that holds the following information

@{[email protected]},@{[email protected]}

I am using this variable for a cmdlet that only accepts data in the format of

[email protected], [email protected]

I have tried TrimStart("@{EmailAddress=") but this only removes @{EmailAddress= for the first user and I guess TrimEnd would not be much use as I presume that it is due to the fact it reading the string as one line and not as user1,user2 etc.

Would anyone be able to provide advice on how to remove these unwanted characters.

Micky Balladelli · Accepted Answer · 2017-04-24 09:59:50Z

3

A possible solution is to use Regex to extract the strings that you want, and combine them into a result:

$str = "@{[email protected]},@{[email protected]}"
$pattern = [regex]'@{EmailAddress=(.+?)}'
$result = ($pattern.Matches($str) | % {$_.groups[1].value}) -join ','

$result then is:

[email protected],[email protected]

answered Apr 24, 2017 at 9:59

Micky Balladelli

10k2 gold badges36 silver badges31 bronze badges

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

Comments

Martin Brandl · Accepted Answer · 2017-04-24 10:06:15Z

2

Another solution would be to use the -replace function. This is just a one-liner:

'@{[email protected]},@{[email protected]}' -replace '@{EmailAddress=([^}]+)}.*?', '$1'

Regex used to replace:

answered Apr 24, 2017 at 10:06

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

3 Comments

Jamie_lee Over a year ago

Thanks Martin, the diagram helped me understand - much appreciated

Jamie_lee Over a year ago

Hi Martin, Sorry to move the goalposts a bit here but is there an option to add double quotes to each of the users for example "[email protected]", "[email protected]" - I appreciate this may be an entirely different question requiring a different response but thought I would ask here first. Thanks

Martin Brandl Over a year ago

Sure, just replace '$1' with '"$1"'

Collectives™ on Stack Overflow

Trim or replace PowerShell string variable

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related