Hash table PowerShell

Question

I need some help to eliminate duplicate entries in a hashtable.

Code:

$username=Get-Content ".\u.txt"
#$username
$fileread=Get-Content ".\lastlogon.txt"
$lastinfo=$fileread|select-string -pattern "logged off" -encoding ASCII
foreach($i in $lastinfo){
    $splitinfo=$i -split("Login ID: ")
    $dateinfo=$splitinfo[0] -split("       ")
    $finaldateinfo=$dateinfo[2] -split(" ")
    #$finaldateinfo[0]
    $userinfo=$splitinfo[1] -split(" ")
    #$userinfo[0]
    $hashinfo= @{$userinfo[0]=$finaldateinfo[0]}
    #$hashinfo
    foreach($h in $hashinfo.GetEnumerator()){
        foreach($a in $username){
            if($hashinfo.ContainsKey($a)){
                "$($hashinfo.keys):$($hashinfo.Values)"
            }
        }
    }
}

Result:

Name      Value
----     -----
USERID 08/03/2018
USERID 09/03/2018
USERID 10/03/2018
USERID 13/03/2018
ADM 23/03/2018

The hashtable is like this.

I need only the last entry of USERID to be kept and eliminate all the other values of USERID.

To what do you refer with last entry, the latest date? With several same Names it can't be a hash table key. — user6811411
– user6811411, Commented Nov 17, 2018 at 9:46
You are getting array of small hashtables. You'd need to define a hashtable at the beginning and then feel it out. You probably can make it a bit more efficient - triple foreach seemed to be excessive. Maybe post a sample of your input files — Mike Twc
– Mike Twc, Commented Nov 17, 2018 at 17:49
Please find the input file : u.txt USERID ADM ADM_TM Lastlogon.txt USERID loggedoff 08/03/2018 USERID loggedoff 13/03/2018 — SubatraMahendran
– SubatraMahendran, Commented Nov 18, 2018 at 10:44

JasonTrue · Accepted Answer · 2018-11-17 09:48:20Z

1

I'm a little rusty in Powershell, but I believe you can create a dictionary (hash table) like this:

$LastAccessByUser= @{}

Assuming your source data is already ordered, simple iterate over it. I don't know your variable names, so I'll just provide an example assuming you have a list by the name $list containing Items.

foreach ($item in $list.Items)
{
    $LastAccessByUser[$item.Name] = $item.Value
}

Apologies if it doesn't quite match your scenario, but you should be able to adjust based on what you have.

edited Nov 17, 2018 at 9:48

answered Nov 17, 2018 at 9:41

JasonTrue

19.7k5 gold badges38 silver badges63 bronze badges

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

Comments

Peter Mortensen · Accepted Answer · 2018-12-25 00:55:59Z

1

This can't be a hashtable. As far as I know there can't be any duplicate keys (Name) in a hashtable as that's the purpose of the hashtable - to return values based on unique keys. Please recheck.

If this is an array then,

$lastmatch = $arr | where { $_.Name -match "USERID" } | select -Last 1

Add the above result to a hashtable like,

$ht.Add($lastmatch.Name,$lastmatch.Value)

edited Dec 25, 2018 at 0:55

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Nov 17, 2018 at 9:28

Karthick Ganesan

3851 gold badge5 silver badges13 bronze badges

1 Comment

JasonTrue Over a year ago

The post isn't asking for multiple keys, but to store the last value encountered for each key.

Collectives™ on Stack Overflow

Hash table PowerShell

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related