开发者

Writing list of ChildItem for a list of paths to a CSV file

开发者 https://www.devze.com 2023-03-06 19:19 出处:网络
What I am attempting to do is have an end CSV file like this: path , get-childItem path , get-childItem

What I am attempting to do is have an end CSV file like this:

path , get-childItem

path , get-childItem

path , get-childItem

etc.

I am very new to powershell so as of right now the issue I am having isn't with errors but rather actually knowing what to do

Here is my code thus far:

$data = gc "c:\Documents and Settings\user\Desktop\paths.txt"
ForEach($line in $data) {
$subName = Get-ChildItem "$line"
write-host $line","$subName
#Export-Csv -Path "C:\Documents and Settings\reidli\Desktop\mytest.csv" -Force "true" -InputObject $output 

So I am reading a list of paths from paths.txt where each line is a different path $subName is the list of Children i want and is correct and when I write-host the output开发者_如何学编程 is in fact: path,children commentented out is where I attempted to export csv, but this wont work as it would over-write the existing csv for each path

Can someone please help me take each line in the foreach loop and create a .csv file with each path and children?


just don't use export-csv at all. CSV is plain comma separated text file. which makes it easy to export:

$data = gc "c:\Documents and Settings\user\Desktop\paths.txt"
Remove-Item "C:\Documents and Settings\reidli\Desktop\mytest.csv" -ea 0
ForEach($line in $data) {
  $subName = Get-ChildItem "$line"
  write-host $line","$subName
  "$line,$subName" | Add-Content "C:\Documents and Settings\reidli\Desktop\mytest.csv" 
}

btw. do you really want the sub files space separated? it is what you get when you convert Get-ChildItem to string


Try this:

$data | select $_ , @{L="subname";E=@{(gci $_)}} | Export-Csv "C:\Documents and Settings\reidli\Desktop\mytest.csv" -force
0

精彩评论

暂无评论...
验证码 换一张
取 消