Unless you read the input file into memory in full, up front, you cannot safely read from and write back to the same file in a given pipeline. Specifically, a command such as Import-Csv file.csv | … | Export-Csv file.csv will erase the content of file.csv.[1] The simplest solution is to enclose the command that … Read more
What you’re experiencing is merely a display problem: Both your Select-Object calls produce output objects with 4 or fewer properties whose types do not have explicit formatting data associated with them (as reported by Get-FormatData). This causes PowerShell’s for-display output formatting system to implicitly render them via the Format-Table cmdlet. The display columns that Format-Table … Read more
qbanet359’s helpful answer uses direct property access (.LoadPercentage) on the result object, which is the simplest and most efficient solution in this case. In PowerShell v3 or higher this even works with extracting property values from a collection of objects, via a feature called member-access enumeration. E.g., ((Get-Date), (Get-Date).AddYears(-1)).Year returns 2019 and 2018 when run … Read more
The [System.IO.FileInfo] instances returned by Get-ChildItem for files do not have Folder or FolderName properties. Get-ChildItem -File $HOME\Desktop | Get-Member, for instance, will show you the available properties, and will show you that the desired information can be derived from the PSPath and PSParentPath properties. Select-Object allows hashtable-based property definitions, so-called calculated properties, which allow … Read more