我正在编写一个PowerShell脚本来导出用户的信息，包括他或她所属的SharePoint Group。 部分脚本如下所示：
$web = Get-SPWeb $webURL $users = Get-SPUser -Web $web.Url foreach($user in $users){ $staffObject = New-Object PSObject -Property @{ 'UserID' = $user.LoginName 'Groups' = $user.Groups 'Join Date' = "" 'Referal' = "" } $resultsarray += $staffObject } $resultsarray | Select UserID,@{Name="Groups";Expression={$_."Groups" -join '|'}},'Join Date','Referral' | Export-csv -path $sFileLocation -Append -NoTypeInformation 现在输出结果如下所示：
"UserID","Groups","Join Date","Referal" "123","Group A|Group B|Group C","",""
我如何更改为：
"UserID","Groups","Join Date","Referal" "123","Group A","","" "123","Group B","","" "123","Group C","",""
非常感谢。
这有帮助吗？
$CSV = Import-Csv C:\Users\Ryan\Downloads\test.txt $ReformattedUsers = @() Foreach ($User In $CSV) { Foreach ($Group In $User.Groups.Split('|')) { $ReformattedUsers += [PSCustomObject]@{ 'UserID' = $User.UserID; ` 'Groups' = $Group; ` 'Join Date' = $User.'Join Date'; ` 'Referal (sic)' = $User.Referal } } } $ReformattedUsers | Format-Table -AutoSize $ReformattedUsers | Export-Csv C:\Users\Ryan\Downloads\out.csv -NoTypeInformation
输出：
UserID Groups Join Date Referal (sic) ------ ------ --------- ------------- 123 Group A 123 Group B 123 Group C
生成的CSV如下所示：
"UserID","Groups","Join Date","Referal (sic)" "123","Group A","","" "123","Group B","","" "123","Group C","",""