How to use Select-Object property to expand all the fields in the power shell command

Question

Get-ChildItem -Path E:\Server_Data\data\2015 -Recurse –File -include "*.txt","*.csv" | Where-Object {$_.Name -like "*transaction*"} | Select-Object -ExpandProperty FullName,LastWriteTime

I'm trying to list all files in a folder using Get-ChildItem and Select-Object property. When I try to use FullName variable to list the fully qualified file name, the file name is getting truncated. Tried to use -ExpandProperty to get fully qualified file name. It works for one field but if I try to list both FullName and LastWriteTime, it's not working.

The output from the power shell command will be used in MS SQL Server to load the file names into a specific table.

Please suggest proper syntax for my purpose. Appreciate your help!

Answer 1

Depending on your use case and input, one way to accomplish this is by having two Select-Object cmdlets in your pipeline, one to define an array of properties, and one to expand them:

PS C:\> $Name,$DisplayName,$Status = Get-Service 
  | Select-Object -First 1 -Property @{
    Name = "MyProperties"
    Expression = { $_.Name,$_.DisplayName,$_.DisplayName }
  } | Select-Object -ExpandProperty MyProperties