主页 / computer / 问题 / 1478751
Accepted
stib
Asked: 2019-09-05 00:48:07 +0800 CST

Powershell ConvertTo-Csv 破坏对象

  • 772

说我同意

$d = @{"foo"="bar"; "baz"=99.9}
ConvertTo-csv $d

我期待类似的东西

foo,baz
"bar",99.9

但相反，我得到了这个：

#TYPE System.Collections.Hashtable
"IsReadOnly","IsFixedSize","IsSynchronized","Keys","Values","SyncRoot","Count"
"False","False","False","System.Collections.Hashtable+KeyCollection","System.Collections.Hashtable+ValueCollection","System.Object","2"

似乎将有关对象的元数据放入 CSV，而不是对象的实际内容。

如何获得预期的结果？

powershell csv

1 个回答

  1. Best Answer

    $d是一个带有键（名称）/值对的哈希表，
    首先将其转换为一个对象[PSCustomObject]

    PS> $d

Name                           Value
----                           -----
baz                            99,9
foo                            bar

    PS> [PSCustomObject]$d

 baz foo
 --- ---
99,9 bar

    然后ConvertTo-Csv使用参数-NoTypeInformation

    PS> [PSCustomObject]$d|ConvertTo-Csv -NoTypeInformation
"baz","foo"
"99,9","bar"

    为了保持您的初始订单，请使用有序哈希表

    PS> $d = [ordered]@{"foo"="bar"; "baz"=99.9}

PS> [PSCustomObject]$d|ConvertTo-Csv -NoTypeInformation
"foo","baz"
"bar","99,9"
    • 3

相关问题