我有一个包含大约 10,000 行的 XML 文件，我想将一些数据提取到 CSV 文件中。

我遇到的问题是提取 id 属性和联盟名称标签的内部文本。如果有人能阐明为什么不显示 ID 以及如何获取内部文本，那将非常有帮助。

重复样本数据

<players>
<towns>
  <town>
    <player>
      <playername id="1">MyName</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="2">Tonka</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="18">DaVS</alliancename>
        <alliancetag>DaVS</alliancetag>
        <alliancetax>0.01</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="3">Sinner</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="1">Harmless?</alliancename>
        <alliancetag>TH</alliancetag>
        <alliancetax>0.00</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="3">Sinner</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="1">Harmless?</alliancename>
        <alliancetag>TH</alliancetag>
        <alliancetax>0.00</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="3">Sinner</playername>
      <playerrace>Human</playerrace>
      <playeralliance>
        <alliancename id="1">Harmless?</alliancename>
        <alliancetag>TH</alliancetag>
        <alliancetax>0.00</alliancetax>
      </playeralliance>
    </player>
  </town>
  <town>
    <player>
      <playername id="10">Kumomoto</playername>
      <playerrace>Elf</playerrace>
      <playeralliance>
        <alliancename id="1">Harmless?</alliancename>
        <alliancetag>TH</alliancetag>
        <alliancetax>0.00</alliancetax>
      </playeralliance>
    </player>
  </town>
  </towns>
</players>

当前代码

$xml.selectNodes('//playeralliance') |
  select alliancename.id, allianceticker, alliancetaxrate

输出

PS C:\Users\jon> $xml.selectNodes('//playeralliance') | select alliancename.id, alliancename, alliancetag, alliancetax

alliancename.id alliancename alliancetag alliancetax
--------------- ------------ ----------- -----------
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename DaVS           0.01           
                alliancename TH             0.00           
                alliancename TH             0.00           
                alliancename TH             0.00           
                alliancename TH             0.00               

过去的代码示例

[xml]$xml = Get-Content 'C:\Users\jhold\Desktop\Illyriad Data\sample.xml';

$xml.towns.town.player;

foreach($item in $xml.playeralliance)
{
    $allianceName = $item
    #$allianceID = $item.id
    #$allianceTicker = $item.allianceticker
    #$allianceTax = $item.alliancetax

    Write-host "Name: " $allianceName 
    #Write-host "ID: " $allianceID
    #Write-host "Ticker: " $allianceTicker
    #Write-host "Tax: " $allianceTax
}

最佳答案

使用calculated properties为此:

$xml.SelectNodes('//playeralliance') |
  Select-Object @{n='allianceid';e={$_.alliancename.id}},
                @{n='alliancename';e={$_.alliancename.'#text'}},
                @{n='allianceticker';e={$_.alliancetag}},
                @{n='alliancetaxrate';e={$_.alliancetax}}

关于xml - 从 XML 中提取属性和内部文本，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/34302981/