How to get content a file with system.array type data and sort it using PowerShell?

Question

I want to get the contents of a file.

The format of file is like this

Disk0MapForUefiBootOrder
    PciRoot(0x0)/Pci(0x14,0x0)

    PciRoot(0x0)/Pci(0x1B,0x0)/Pci(0x0,0x0)/NVMe(0x1,7D-F0-B6-71-B7-38-25-00)

    PciRoot(0x0)/Pci(0x1B,0x4)/Pci(0x0,0x0)/NVMe(0x1,00-00-00-00-00-00-00-00)

    PciRoot(0x0)/Pci(0x17,0x0)/Sata(0x1,0xFFFF,0x0)

    BBS(0xFFFF,,0x0)/PciRoot(0x0)/Pci(0x14,0x0)

Fast Charge
    Disable
    *Enable

......

I want to read the value of this Disk0MapForUefiBootOrder which contains NVMe and Sata, which are:

PciRoot(0x0)/Pci(0x1B,0x0)/Pci(0x0,0x0)/NVMe(0x1,7D-F0-B6-71-B7-38-25-00)

PciRoot(0x0)/Pci(0x1B,0x4)/Pci(0x0,0x0)/NVMe(0x1,00-00-00-00-00-00-00-00)

PciRoot(0x0)/Pci(0x17,0x0)/Sata(0x1,0xFFFF,0x0)

and pass it to the output file. Then I have to sort it with a rank.

I tried this, but I can only read the content. But I can not rank it.

Can anyone help me please?

$FileContents = Get-Content "D:\Boot\file.txt" | Select-String -Pattern "PciRoot" | Out-File D:\Boot\Out2 -Force
    $FileContents
    $Rank = @{
        'NVMe' = 1
        'Sata' = 2
    }
    $FileContents |
        Where-Object { $Rank.Contains("NVMe" -and "Sata") } | Sort-Object {[int64]$_.Size} |
        Sort-Object { $Rank["NVMe" -and "Sata"] }|
        Export-Csv 'Output.csv' -NoType

AdminOfThings · Accepted Answer · 2019-11-04 13:04:35Z

1

You can do the following if we assume that the data you want is indented:

$found = $false
switch -regex -file file.txt {
    'Disk0MapForUefiBootOrder' { $found = $true; continue }
    'nvme|sata' { if ($found) { $_.Trim() }}
    '^\S' { if ($found) { return }}
}

edited Nov 4, 2019 at 13:04

answered Nov 4, 2019 at 11:35

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

4 Comments

Cheries Over a year ago

I still have a problem how to sort it, I want to create a rank of those data, If the nvme rank 1, it will return true, and false if sata rank 1. Could you please help me, Thank you buddy

AdminOfThings Over a year ago

Can you explain how you want to sort? It doesn't seem clear because your code is sorting by Size and the size property is not present in the file exerpt.

Cheries Over a year ago

The output is an array. So if the array[0] is contain of 'sata', it will return false

Cheries Over a year ago

I have to output the return first to a file, then read the output file

Dany · Accepted Answer · 2019-11-04 10:12:53Z

0

You could use Select-String with -Pattern.

$FileContents= Get-Content $FilePath | Select-String -Pattern "NVMe|Sata"

answered Nov 4, 2019 at 10:12

Dany

1262 bronze badges

Collectives™ on Stack Overflow

How to get content a file with system.array type data and sort it using PowerShell?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related