Question:
How to export powershell’s hashtable into CSV file using Export-Csv ?
|
1 2 3 4 5 6 7 |
PS C:\>$UsersAndGroups Name Value ---- ----- user1 {Group2} user2 {Group1, Group2, Group3} user3 {Group3, Group4} |
I want to get this into CSV file where each key-value pair is in new line. First column should allways be key and next columns should be values.
Like this:
|
1 2 3 4 5 6 |
|col1 col2 col3 col4 +------------------------------ 1|User1 Group2 2|User2 Group1 Group2 Group3 3|User3 Group3 Group4 |
Thank you very much.
Answer:
One way:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
$usersandgroups = @{ user1 = @("group2") user2 = @("group1","group2","group3") user3 = @("groupt3","group4") } $exp = @("col1,col2,col3,col4") $usersandgroups.keys |%{ $exp += (@($_) + $usersandgroups.$_) -join "," } $exp $exp | out-file test.csv $imp = import-csv test.csv $imp | ft -auto col1,col2,col3,col4 user3,groupt3,group4 user1,group2 user2,group1,group2,group3 col1 col2 col3 col4 ---- ---- ---- ---- user3 groupt3 group4 user1 group2 user2 group1 group2 group3 |