powershell - Export csv spits out length only

Question

I can only get the length when exporting this to csv, how should it be done properly.

$redo = Import-CSV c:empestimport.txt | Group-Object email |
foreach {  "{0} ,{1}" -f $_.Name, (($_.Group | foreach { $_.group }) -join ', ')

}

$redo | Export-CSV c:empest.csv -NoTypeInformation

#

"Length" "46" "59" "110" "47" "149" "38" "69" "32" "62" "29" "49" "31" "27" "48" "55" "42"

Answer 1

Export-Csv expects an object (or a list of objects) with properties, whereas your command pipeline produces an array of strings. If you feed this array into Export-Csv the cmdlet takes the properties of each given item (which is only Length for strings) and writes those properties to the output file.

You need to build a list of objects with the desired properties instead, e.g.:

Import-CSV c:empestimport.txt `
  | Group-Object email `
  | select @{n="Name";e={$_.Name}},@{n="Group";e={($_.Group | %{$_.group}) -join ', '}} `
  | Export-CSV c:empest.csv -NoTypeInformation