Split a string to multiple strings in powershell

Question

I have strings like

$value = "1;#Mohapatra,Mrutyunjaya (ADM) 10;#Sumit Upadhyay(ADM) 11;#Naidu,Ishan(ADM)"

I want to retrieve

"Mohapatra,Mrutyunjaya (ADM)", "Sumit Upadhyay(ADM)", "Naidu,Ishan(ADM)"

from $value.

I have tried $value.Split(";#")[0]. It is returning the first parameter only. But I want all the parameters

Is there something you have tried we can help you fix? It is expected that you have tried something first that we can help you fix. — Matt
– Matt, Commented Nov 19, 2015 at 13:49
I had used $value.Split(";#")[0]. It is returning the first parameter only. But I want all the parameters — Mrutyunjaya Mohapatra
– Mrutyunjaya Mohapatra, Commented Nov 19, 2015 at 13:54
How are you obtaining the string of user values? Since you tagged the question with SharePoint-2010, I'm guessing these strings that you're trying to parse are values from a person or group field. In Powershell, you can access the values of a multi-select person or group field directly, using the format of $item["Field"][i].LookupValue or $item["Field"][i].User.DisplayName where i is an index greater than or equal to 0 and less than $item["Field"].Count, $item is a list item, and Field is the internal name of the column you're accessing. — Thriggle
– Thriggle, Commented Nov 19, 2015 at 16:15

Ansgar Wiechers · Accepted Answer · 2015-11-19 14:06:24Z

3

Split your string at sequences of \s*\d+;# (optional whitespace, followed by a number, a semicolon, and a hash character), and remove empty elements from the resulting list:

$value -split '\s*\d+;#' | Where-Object { $_ }

answered Nov 19, 2015 at 14:06

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Comments

Nate · Accepted Answer · 2015-11-19 14:49:07Z

1

Just FYI, if you want to declare each as a variable you can say $a,$b,$c,$d = $Value -Split (";#") and each of $a, $b, $c and $d will retain those values.

answered Nov 19, 2015 at 14:49

Nate

8621 gold badge10 silver badges30 bronze badges

Collectives™ on Stack Overflow

Split a string to multiple strings in powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related