Powershell:如何将Format-Table与XML数据一起使用
发布时间:2020-12-16 07:58:50 所属栏目:百科 来源:网络整理
导读:tickets type="array" ticket assigned-user-id type="integer"123/assigned-user-id closed type="boolean"true/closed creator-id type="integer"177522/creator-id number type="integer"306/number stateresolved/state tag nil="true"/ title title tex
<tickets type="array"> <ticket> <assigned-user-id type="integer">123</assigned-user-id> <closed type="boolean">true</closed> <creator-id type="integer">177522</creator-id> <number type="integer">306</number> <state>resolved</state> <tag nil="true"/> <title> title text 1 </title> <updated-at type="datetime">2012-03-14T13:13:11+11:00</updated-at> <user-id type="integer">96438</user-id> <version type="integer">3</version> <user-name>Username</user-name> </ticket> </tickets> 我是一个Powershell新手,并在xml和format-table上找到一个问题.给出上面的xml文件.如果我在脚本下面运行以在表格中显示票证,则无法显示“数字”,“已关闭”的值 $t = [xml](new-object system.net.webclient).downloadstring($xmlfilepath) $t.tickets.ticket | Format-Table -Property title,state,user-name,url,number,closed 返回: title state user-name number closed ----- ----- --------- ------ ------ title text 1 resolved Username number closed title text 2 resolved Username number closed 这是我必须使用foreach和selectSingleNode(“ticket”).get_InnerXml()来获取所有值的唯一方法吗? 谢谢.
如果您注意到这些节点具有属性,那么您将需要获取节点的数据.尝试以下方法:
$t.tickets.ticket | Format-Table -AutoSize -Property title,@{Label="number"; Expression={$_.number."#text"}},@{Label="closed"; Expression={$_.closed."#text"}} (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |