导出 csv 以空白页结尾

Question

我编写了脚本来获取目录、文件名和行数，但是当我导出到 CSV 时，我以空表结尾。做错了什么？

这是我写的代码：

Get-ChildItem C:UsersbiDesktopMOMO_FILES -Include *.txt -Recurse 
$result = % {
$_ | select CreationTime, DirectoryName, name, @{n="lines";e={
Get-Content $_ | Measure-Object -Line | select -expa lines
}}
}
$result | Export-Csv C:UsersbiDesktopfilename.csv -NoTypeInformation

Answer 1

您的问题是您没有将Get-ChildItem部分合并到管道中。您需要这样做：

$result = get-childitem C:UsersbiDesktopMOMO_FILES -Include *.txt -recurse  | % { $_ | select CreationTime, DirectoryName,name, @{n="lines";e={
get-content $_ | 
measure-object -line |
select -expa lines }
} 
} 
$result | Export-csv C:UsersbiDesktopfilename.csv -NoTypeInformation

或者，如果您希望它水平水平一点，请将Get-ChildItem结果发送到变量并使用它：

$files = get-childitem C:UsersbiDesktopMOMO_FILES -Include *.txt -recurse 
$result = $files | % { $_ | select CreationTime, DirectoryName,name, @{n="lines";e={
get-content $_ | 
measure-object -line |
select -expa lines }
} 
} 
$result | Export-csv C:UsersbiDesktopfilename.csv -NoTypeInformation