Partial Replace in Powershell

Question

Let's say we have the following code

Get-ADUser -Filter {Enabled -eq $false} -properties * | sort Surname| FT GivenName, Surname, description

It produces:

 GivenName      Surname           description                          
 ---------      ---------         ------- -----------                                              
 Tom            Abbott            AccountingSystems 
 Tim            Baker             AccountingSystems 
 Tyler          Cabot             AccountingSystems

I need to put a space in between 'Accounting' and 'System'

I thought this would work:

Get-ADUser -Filter {Enabled -eq $false} -properties *
% {
   $Description = $.replace("Accounting","Accounting ")
   Set-ADUser = -Description $Description
  }

But... it does not.

This looks wrong... Maybe more like this $_.Description.replace("Accounting","Accounting ") — Sage Pourpre
– Sage Pourpre, Commented Feb 3, 2020 at 21:15
As an aside: If this answer is correct, Enabled -eq $false doesn't actually work as intended. Does it? — mklement0
– mklement0, Commented Feb 3, 2020 at 22:13

Jawad · Accepted Answer · 2020-02-03 21:26:25Z

1

There are a few things I would recommend you look into,

There is no such variable as $. When you are looping through items with ForEach, you have to use $_ (with underscore)
You cannot assign value to a cmdlet (Set-ADUser = ).
You use | then % (not % | )

Try this,

Get-ADUser -Filter {Enabled -eq $false} -properties Description | % {
   if ($_.Description) {
       $description = $_.Description.replace("Accounting","Accounting ") 
       Set-ADUser $_ -Description $Description
   } # else description is null.
}

Documentation for Set-ADGroup
Documentation for ForEach

edited Feb 3, 2020 at 21:26

answered Feb 3, 2020 at 21:15

Jawad

11.4k3 gold badges28 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Partial Replace in Powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related