How do I replace an array with multi values with a specific value?

Question

How do I replace an array with multi values with a specific value?

Mike 251

Example: Name:Mario Samaccountname:sMario Name:Luigi SamaccountName:sLuigi I want to replace sLuigi with xLuigi.

Rich Matheisen 47,901 Reputation points

2021-03-09T19:31:14.077+00:00
An array may have multiple items, but an array item has only its literal value. You can have an array of PSCustomObjects, and each PSCustomObject may have multiple values, but from the perspective of the array each element is is just a PSCustomObject.

So, do you have an array? Or do you have a hash? A has has a key (which cannot be duplicated) and a value, which appears to be what you're describing:

$x = @{ "Mario"="sMario" "Luigi"="sLuigi" }

3 answers

Your answer

Rich Matheisen 47,901 Reputation points

2021-03-09T19:31:14.077+00:00

An array may have multiple items, but an array item has only its literal value. You can have an array of PSCustomObjects, and each PSCustomObject may have multiple values, but from the perspective of the array each element is is just a PSCustomObject.

So, do you have an array? Or do you have a hash? A has has a key (which cannot be duplicated) and a value, which appears to be what you're describing:

$x = @{ "Mario"="sMario" "Luigi"="sLuigi" }

Answer 1

Mike 251

and how to I remove Name:Mario Samaccountname:sMario

Answer 2

Mike 251

if I save my variable to txt, it looks like this.

DisplayName: Mario
Name: Mario S.
email: MarioS@xyz .com
samaccountName: marios

Displayname: Luigi
Name: Luigi S.
email: LuigiS@xyz .com
samaccountName: luigis

I am hoping to update it if a samaccountname exist in my hash

$x= [PSCustomObject]@{tSamaccountname='luigis';gSamaccountname='marios'}, [PSCustomObject]@{tSamaccountname='newLuigi';gSamaccountname='newMario'}
$h = @{}
$x |
ForEach-Object{
$h.($.tSamaccountname) = $.gSamaccountname
}

Rich Matheisen 47,901 Reputation points

2021-03-09T22:22:04.363+00:00

So your "variable" is an array of strings?

If you find a string in the array that contains "samaccountName:" you want to get the string that follows it (e.g. "luigis) and see if that exists in your hash table? If it does you want get the value associated with that key and replace the string in the array with the value from the hash?

For example, this set of strings in the array:

Displayname: Luigi
Name: Luigi S.
email: LuigiS@xyz .com
samaccountName: luigis

Will become:

Displayname: Luigi
Name: Luigi S.
email: LuigiS@xyz .com
samaccountName: marios

Answer 3

Anonymous

Hi @Mike ,

Is the variable an array of PSCustomObjects with the properties DisplayName, email, Name and samaccountName? If so, you can do something like the following

$var | ForEach-Object {  
    if($h[$_.samaccountName]){  
        $_.samaccountName = $h[$_.samaccountName]  
    }  
}

It will replace the value 'luigis' of the samaccountName property with the value 'mario' to the key 'luigis' of your hashtable $h.

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Mike 251 Reputation points

2021-03-10T09:46:18.4+00:00

hi Ian,

Thanks.

will this still be correct
$var | ForEach-Object {
if ($.samaccountName -eq $h[$.samaccountname]){
$.samaccountname = $h[$.samaccountname]
}}
with the intent to replace them with the key only if there is an equal value.

if in case I wanted to remove the entire particular record like displayname,name,email and someaccountname.
DisplayName: Mario
Name: Mario S.
email: MarioS@xyz .com
samaccountName: marios
how should i do that?
Anonymous

2021-03-10T10:24:45.563+00:00
The $_.samaccountName, which is 'luigis' here, is the value of the property samaccountName , and $h[$_.samaccountname] is 'marios' which is the value to the key 'luigis' in the hashtable $h.
To remove an item from the array you have to convert it to an arraylist

$var2 = [System.Collections.ArrayList]$var $var | ForEach-Object { if($h[$_.samaccountName]){ $var2.Remove($_) } }
Mike 251 Reputation points

2021-03-10T10:43:57.897+00:00

i did encounter some issue though
if i do this
foreach($terminaluser in $Terminalusers)
{
if ($h[$terminaluser.samaccountname]){
$terminaluser.samaccountname = $h[$terminaluser.samaccountname]
}}}
Error is
Exception Setting "
Anonymous

2021-03-11T08:08:03.6+00:00

It looks fine to me. Can you provide the full error message?

Share via

How do I replace an array with multi values with a specific value?

3 answers

Your answer