#PSTip Using XPath in PowerShell, Part 6

When we analyze XML documents with XPath we may need information about number of certain items. For example, we can have an XHTML document with several tables and we can easily check which tables contain rows with ‘class’ attribute:

$Common = @{
    Path = 'SomeTables.xhtml'
    Namespace = @{
        d = 'http://www.w3.org/1999/xhtml'
    }
}

Select-Xml -XPath '//d:table[d:tr[@class]]' @Common | 
    ForEach-Object { $_.Node } | Format-Table -AutoSize
 
id             colgroup tr                 
--             -------- --                 
withZebra      colgroup {tr, tr, tr, tr...}
withSmallZebra colgroup {tr, tr, tr}       

Note: You can find the input SomeTables.xhtml file here.

We nested one query within the other so that result will be table that contain rows with ‘class’ attribute defined. Now let’s try to get information about numbers–we may want to list only tables that have more than one row defined with ‘class’ attribute and for that we will use count() function:

Select-Xml -XPath '//d:table[count(d:tr[@class]) > 1]' @Common | 
    ForEach-Object { $_.Node } | Format-Table -AutoSize

id        colgroup tr                 
--        -------- --                 
withZebra colgroup {tr, tr, tr, tr...}

And last but not least: we may use count() function few times in one query and compare the results, e.g. to get all tables where number of rows without ‘class’ attribute is higher than number of rows with that attribute:

Select-Xml -XPath '//d:table[count(d:tr[@class]) < count(d:tr[not(@class)])]' @Common | 
    ForEach-Object { $_.Node } | Format-Table -AutoSize

id             colgroup tr                 
--             -------- --                 
withoutZebra   colgroup {tr, tr, tr, tr...}
withSmallZebra colgroup {tr, tr, tr}       

About the author: Bartek Bielawski

Bartek is a busy IT Admin working for an international company, Optiver. He loves PowerShell and automation. That love got him the honors of a Microsoft MVP. He shares his knowledge on his blog. You can also find him on Twitter: @bielawb.

Related Posts

%d bloggers like this: