Powershell read a variable value and sub-string

Question

I am writing a powershell script read last column value into a variable and get numeric value component
this powershell returns as follows $LatestFullBackupFile = Get-ChildItem -Path $BackupDir -Filter $SourceDbbkp*.bak | Sort-Object LastWriteTime -Descending | Select-Object -First 1 Write-Output $LatestFullBackupFile ++++++++++++++++++++ output: Mode LastWriteTime Length Name

---

-a---- 21/04/2023 3:56 AM 565042614272 PRODCRM_backup_202304210300.bak so how do i delimiter given output to get last column PRODCRM_backup_202304210300.bak" value? any idea would be highly appreciate

Answer 1

You can do it this way:

$LatestFullBackupFile = Get-ChildItem -Path $BackupDir -Filter $SourceDbbkp*.bak | 
    Sort-Object LastWriteTime -Descending | 
        Select-Object -First 1 -Expand Name