每个CSV行中的每个pc和用户都有一个连接,是由库存软件生成的。
CSV文件:"pc1";"user1"
"pc2";"user2"
"pc3";"user3"
新手代码:
$csv = IMPORT-CSV ~desktopreport.csv
$computersCsv = get-magicallyColumn1
$usersCsv = get-magicallyColumn2
$i = 0
Foreach ($computersCsv in $usersCsv) {
W7path = \computersCsv[$i]c$usersusersCsv[$i]desktop
if(Test-Path W7){
"not matters - the size is $size"
if($size -gt "some bytes"){
Add-Content ~desktopNewReport.csv "THAT MATTERS ComputersCsv[$i] userCsv[$i] $size"
}
}
else{
"Error! - bad connection"
}
$i++
}
您不需要单独收集csv行,powershell可以很好地管理这一点。不太确定你想要达到什么目的,但这里有一些帮助:
$csv = import-csv test.csv -Delimiter ";" -Header PCName, User
echo $csv #debug purposes
foreach($item in $csv)
{
echo "this is the first pc name"
echo $item.PCName
$pc = $item.PCName
echo "This is the first user name"
echo $item.User
$user = $item.User
$W7path = \$PCnamec$users$Userdesktop
if(Test-Path $W7path){
"not matters - the size is $size"
if($size -gt "some bytes"){
Add-Content ~desktopNewReport.csv "THAT MATTERS $item.PCname $item.User $size"
}
}
else{
echo "Error! - bad connection"
}
}
希望能有所帮助