Split with string in Powershell

Question

I have a problem with a quick function I wrote for splitting Sharepoint specific ids ({id};#{name}):

function GetOnlyValue {
param( 
[string] $fullValue
)

if(![string]::IsNullOrEmpty($fullValue))
{
    # On regarde si on a la valeur
    if($fullValue -Like "*;#*")
    {
        $array = $fullValue -split ";#", 2, "simplematch"

        return $array[-1]
    }
}

return $fullValue
}

But this function does half the job because, for instance, when I pass a value formated like that : myId;#myName the function return me this value: "#myName" instead of "myName".

Thanks for your help !

06/02/2016 EDIT: This function is included in a module that I import in a script. I use it in correlation with a Sharepoint 2013 site, browsing each SPListItem of a SPList:

$formation = GetOnlyValue -fullValue $spItem["Formation"]

Cannot reproduce here. 'myId;#myName' -split ';#',2,'simplematch' works as expected. — Joey
– Joey, Commented Jun 2, 2016 at 15:01
I used simple and double quotes, I've always the same result :/ — GwenGuts
– GwenGuts, Commented Jun 2, 2016 at 15:16
try to output $spItem["Formation"] and ensure its a string — Martin Brandl
– Martin Brandl, Commented Jun 2, 2016 at 15:48
Hi, so it works now, by ensuring the data is a string -__- : GetOnlyValue -fullValue ([string]$item["Formation"]) Thanks to all for your help ! — GwenGuts
– GwenGuts, Commented Jun 3, 2016 at 7:22

beatcracker · Accepted Answer · 2016-06-02 15:04:26Z

1

I'd use a regex with capture groups:

function GetOnlyValue
{
    Param
    ( 
        [string]$fullValue
    )

    if($fullValue -match '(.*);#(.*)'){
        $Matches[2]
    }
}

answered Jun 2, 2016 at 15:04

beatcracker

6,9601 gold badge22 silver badges44 bronze badges

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

3 Comments

Joey Over a year ago

Not really a reason for that; their code should work fine. Not everything needs to be bashed at with regexes, especially if the code is not broken to begin with.

beatcracker Over a year ago

@Joey Yep, so it's up to OP to decide. I'm merely suggesting.

GwenGuts Over a year ago

Nope, even with the regex, I have the problem

Martin Brandl · Accepted Answer · 2016-06-02 15:23:55Z

0

I can't reproduce your problem, but you can simplify your script using a -replace:

function GetOnlyValue {
    param( 
        [string] $fullValue
    )

    $fullValue -replace '^.*#'
}

answered Jun 2, 2016 at 15:23

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

5 Comments

GwenGuts Over a year ago

Again, it cut at the ';' but not at the ';#' group.Thanks anyway !

GwenGuts Over a year ago

For instance: 457;#FirstName LastName - Organization. I have in output: #FirstName LastName - Organization

Martin Brandl Over a year ago

I have in output FirstName LastName - Organization.

Joey Over a year ago

Note that your code is not identical to what they have in their question. For a string containing two # yours would remove everything up to the second, whilst theirs would split at the first.

Martin Brandl Over a year ago

yes, to fix that he had to make the dot non greedy (`^.*?#')

Collectives™ on Stack Overflow

Split with string in Powershell

2 Answers 2

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related