Sorting in file. Pls help me

oleg-ieroshenko · March 14, 2016, 12:45am

wilfredo-perez · March 14, 2016, 1:43am

You can use sort-object: This is what I got:

random-commandline · March 14, 2016, 3:24am

# If the pipe, '|', exists in file, create pscustomobject
Get-Content .\myfile.txt | ConvertFrom-Csv -Delimiter '|' -Header 'IP Address','Device','VLAN' | Sort-Object -Property 'IP Address'

oleg-ieroshenko · March 14, 2016, 3:50am

Thanks Wilfredo. I tried to do it via regular expression, but it is easy that I thought.

oleg-ieroshenko · March 16, 2016, 10:59pm

random-commandline · March 16, 2016, 11:20pm

If the pipe, ‘|’, is used to separate parts of your file, then my previous post should work.

bobmccoy · March 17, 2016, 12:05am

No it won’t. That’s because you’re sorting as a string. In that case “10.0.16.255” comes before “10.0.16.5”. You need to convert the IP address into something that is sortable. The trick most often used is to cast it at [version] which can then be properly sorted. For instance …

$data = Get-Content -Path C:\Ephemeral\iptext.txt | 
    ConvertFrom-Csv -Delimiter '|' -Header 'IP','Name','Notes','Other'
$results = foreach ($item in $data)
{
    [PSCustomObject]@{
        IP = [version]$item.IP
        Name = $item.Name
        Notes = $item.Notes
        Other = $item.Other
    }
}
$results | sort -Property IP | Out-GridView

This also assumes correct header alignment, which I can’t guarantee since your two samples are different, e.g., your second sample has a leading bar character whereas your first didn’t.

random-commandline · March 17, 2016, 12:56am

Bob, you are right. After testing with a larger list, I noticed 10.0.16.255 was listed before 10.0.16.5. My post worked with the initial (smaller) list, but not a larger list. Casting the IP address is required.

# Cast
select-object -Property @{n='ip address';exp={[version]$_.'ip address'}}

oleg-ieroshenko · March 17, 2016, 1:12am

yes. it works. Thanks you. How i can add again my delimeter ‘|’ to file?

anthony-stringer · March 17, 2016, 2:03am

$results = Get-Content C:\Test\iptxt.txt |
    ConvertFrom-Csv -Delimiter '|' -Header 'IP','Name','Notes','Other' |
    Sort-Object {[version]$_.ip}

$results | Export-Csv C:\Test\iptxtresults.csv -Delimiter '|' -NoTypeInformation

# another (not recommended) option so the final result does not have quotes.
# it appears that your original file has a space on either side of the '|'
# you can add that back in the following line if needed
$results | % {"$($_.ip)|$($_.name)|$($_.notes)|$($_.other)"} | Out-File C:\Test\iptxtresults.txt

Topic		Replies	Views
Sort-Object a List PowerShell Help	1	215	November 17, 2022
Sorting Not working as expected PowerShell Help	8	194	July 11, 2018
Help with Sort-Object PowerShell Help	3	134	November 15, 2013
Sort a list but have 2 specific objects at the top PowerShell Help	6	136	July 25, 2013
PowerShell equivalent to sort\|uniq -c\|sort -nr PowerShell Help	4	301	October 21, 2016

Sorting in file. Pls help me

Related Topics