POWERSHELL: Regex Find and replace

Question

I want to search and replace parts of UserObject paths using regex.

If you query windows for Users in Local Groups it returns the members as in the example below. Local users are displayed with an domain related prefix and i want to find this domain prefix an delete it form local user paths.

Return Value:

\\MyDomain\PCTest\John Doe   #(Local User)
\\MyDomain\Julie Doe         #(Domain User)

After Formating: (how can i do this?)

\\PCTest\John Doe             #(Local User)
\\MyDomain\Julie Doe          #(Domain User)

Shay Levy · Accepted Answer · 2013-01-30 11:53:44Z

2

This will remove the first element if the path contains more than two elements:

'\\MyDomain\PCTest\John Doe','\\MyDomain\Julie Doe' | Foreach-Object{

    if( ($items = $_.Split('\',[System.StringSplitOptions]::RemoveEmptyEntries)).Count -gt 2)
    {
        '\\'+ ($items[1..$items.count] -join '\')

    }
    else
    {
        $_
    }
}

\\PCTest\John Doe
\\MyDomain\Julie Doe

answered Jan 30, 2013 at 11:53

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

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

Comments

Loïc MICHEL · Accepted Answer · 2013-01-30 11:43:57Z

0

supposing your values are stored in c:\temp\users.txt :

gc C:\temp\users.txt |%{if ($_ -match "local"){$_.replace("MyDomain\","")}}

edit :

$slices="\\MyDomain\PCTest\John Doe".split('\')
if($slices.Count -eq 5){wh "\\$($slices[3])\$($slices[4])"}

edited Jan 30, 2013 at 11:43

answered Jan 30, 2013 at 10:17

Loïc MICHEL

26.3k10 gold badges79 silver badges111 bronze badges

1 Comment

PointerNullException Over a year ago

Hi, Local and Domain are comments they're not appering in the file/object. My start value is an array with mixed entries like in the Example RETURN VLAUE obove. In this arry are multiple entries for domain and local users. I only want to Trim/Replace the Domain referenz form the local user like "John Doe" above.

Ansgar Wiechers · Accepted Answer · 2013-01-30 12:07:25Z

0

"\\MyDomain\PCTest\John Doe", "\\MyDomain\Julie Doe" | % {
  $_ -replace '\\MyDomain(\\.*\\)', '$1'
}

answered Jan 30, 2013 at 12:07

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Comments

mjolinor · Accepted Answer · 2013-01-30 13:00:53Z

0

Another possibility:

'\\MyDomain\PCTest\John Doe','\\MyDomain\Julie Doe' |
ForEach-Object {
'\\{0}\{1}' -f $_.split('\')[-2,-1]
}

answered Jan 30, 2013 at 13:00

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

POWERSHELL: Regex Find and replace

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related