Sort a listbox

Hello,

To do this, you can use some built-in features of PowerShell.

Get-Content "\\path\Parc.txt" | ForEach-Object { $_.split(';')[0] } extracts the first field from each line.

Sort-Object | Select-Object -Unique sorts the list and removes duplicates.

Then, the foreach loop adds each unique and sorted item to the ListBox.

# Creating the ListBox $ListePC = New-Object System.Windows.Forms.ListBox $ListePC.Location = New-Object System.Drawing.Point(350,40) $ListePC.Size = New-Object System.Drawing.Size(300,20) $ListePC.Height = 160 # Reading the file and extracting the first field $Computers = Get-Content "\\path\Parc.txt" | ForEach-Object { $_.split(';')[0] } # Sorting the items and removing duplicates $UniqueSortedComputers = $Computers | Sort-Object | Select-Object -Unique # Adding the sorted and unique items to the ListBox foreach($Computer in $UniqueSortedComputers) { [void]$ListePC.items.add($Computer) } # Adding the ListBox to the form $form.Controls.Add($ListePC) 

Yes, if you want to display multiple columns in your graphical interface, like area [2] and area [3] in addition to area [1] while sorting by area [1], a ListView would indeed be more suitable than a ListBox, as it allows for multiple column handling.

Here’s how you can adapt your script to use a ListView with multiple columns and sort the items based solely on the first area (area [0]).

# Creating the ListView $ListView = New-Object System.Windows.Forms.ListView $ListView.Location = New-Object System.Drawing.Point(350,40) $ListView.Size = New-Object System.Drawing.Size(500,200) $ListView.View = [System.Windows.Forms.View]::Details $ListView.FullRowSelect = $true # Adding columns $ListView.Columns.Add("Zone 1", 150) # To display area [0] $ListView.Columns.Add("Zone 2", 150) # To display area [2] $ListView.Columns.Add("Zone 3", 150) # To display area [3] # Reading the file and extracting areas 1, 2, and 3 $Computers = Get-Content "\\path\Parc.txt" | ForEach-Object { $Zone = $_.split(';') [PSCustomObject]@{ Zone1 = $Zone[0] Zone2 = $Zone[2] Zone3 = $Zone[3] } } # Sorting items by Zone1 $SortedComputers = $Computers | Sort-Object Zone1 # Adding sorted items to the ListView foreach($Computer in $SortedComputers) { $item = New-Object System.Windows.Forms.ListViewItem($Computer.Zone1) $item.SubItems.Add($Computer.Zone2) $item.SubItems.Add($Computer.Zone3) [void]$ListView.Items.Add($item) } # Adding the ListView to the form $form.Controls.Add($ListView) 

The ListView is configured with three columns (Zone 1, Zone 2, Zone 3).
The display mode is set to Details to show the columns.
FullRowSelect allows for entire row selection.

The file is read and transformed into custom objects (PSCustomObject) with three properties: Zone1, Zone2, and Zone3 corresponding to areas [0], [2], and [3] of the file.

Sort-Object Zone1 sorts the items solely based on the first area (Zone1).
 

For each sorted item, a ListViewItem object is created with the first area as the main item, and the other two areas are added as SubItems.