Export array objects to a CSV file

Question

Am trying to output a list of array objects to a CSV file. However, I would like to have the directory, name, lastwritetime and owner in separate columns instead of joining them in one column. Not sure, how to workaround this situation. please see the current code below. The output to gridview and text works fine, but not the csv output.

thx.

$Path = "A:\Test"
$PathArray = @()
$Results = "A:\Test\test_results_7.csv"
$extension = "xml"


# This code snippet gets all the files in $Path that end in extension parameter.
# where the file update was made in the last 30 days
Get-ChildItem $Path -Filter "*.$extension" -recurse |


Where-object { $_.LastWriteTime -ge (Get-Date).AddDays(-30)} |

ForEach-Object {
$PathArray += -join ($_.Directory , " , " , $_.Name , " , " , $_.LastWriteTime , " , " , ((Get-ACL $_.Fullname).Owner) ) 
} 

$PathArray += -join ("Path Location" , " , " , "File name" , " , " , "Last Write Time" , " , " ,  "Owner" ) 


#$PathArray   | Out-GridView 
$PathArray  | select-object $PathArray | ForEach-Object {$_} | Export-csv $Results

techguy1029 · Accepted Answer · 2019-10-03 21:32:52Z

1

Try this:

$folders = Get-ChildItem $Path -Filter "*.$extension" -recurse | Where-object {$_.LastWriteTime -ge (Get-Date).AddDays(-30)} 
$outarray = @()

foreach($folder in $folders)
{
    $outarray += New-Object PsObject -property @{
        'Name' = $folder.FullName
        'Directory' = $folder.Directory
        'LastWrite' = $folder.LastWriteTime
    }
}

$outarray | export-csv $results

I got the answer here

answered Oct 3, 2019 at 21:32

techguy1029

8311 gold badge12 silver badges33 bronze badges

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

1 Comment

Sam Over a year ago

Thank you for the solution - works great. I just made a quick update to obtain the owner name in the array with the following --> 'Owner' = (Get-ACL $folder.Fullname).Owner

Collectives™ on Stack Overflow

Export array objects to a CSV file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related