Re: [xsl] word list and count from the text in an xml document

Subject: Re: [xsl] word list and count from the text in an xml document
From: "Mark" <mark@xxxxxxxxxxxx>
Date: Sat, 12 Jun 2010 15:37:53 -0700
Thanks Michael, I do have the book but for some stupid reason never looked!
Regards,
Mark


-------------------------------------------------- From: "Michael Kay" <mike@xxxxxxxxxxxx> Sent: Saturday, June 12, 2010 3:27 PM To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Subject: Re: [xsl] word list and count from the text in an xml document

You will find the solution to this example on p19 of my book, XSLT 2.0 and XPath 2.0 Programmer's Reference. In case you don't have the book, here is the code (but if you do have the book, you get an explanation as well!)

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet
   version="2.0"
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>

<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
<wordcount>
<xsl:for-each-group group-by="." select="
for $w in //text()/tokenize(., '\W+')[.!=''] return lower-case($w)">
<xsl:sort select="count(current-group())" order="descending"/>
<word word="{current-grouping-key()}" frequency="{count(current-group())}"/>
</xsl:for-each-group>
</wordcount>
</xsl:template>


</xsl:stylesheet>

This is sorted by frequency - I leave it as an exercise to sort by the word value instead.

Michael Kay
Saxonica

On 12/06/2010 21:51, Mark wrote:
Hi,
I have been floundering around in the xsl-list archives for a while looking for a way to get a listing and count of all the words in every instance of a specific element. Thousands of hits, but I think I am not using the correct search terms. I know what I want must be in the archive, but I just can't seem to narrow my search enough to find it.


Given a fragment like (and concentrating on the moment on the lang="en" element):
<Description>
<Data lang="cz"> bmla skvrnka na spodnm casti pmsmene L ve SLOV</Data>
<Data lang="en">white splotch on the lower bar on the L in SLOV</Data>
</Description>
<Description>
<Data lang="cz">barevn} bod pod dolnmm ramem vlevo od VHB</Data>
<Data lang="en">dot on the lower frame to the left of VHB</Data>
</Description>


I would like to create a list like the one below (it would be nice to be able to use a "stop word" list also so as to not count stuff like "on", ""the", etc.):
bar 1
dot 1
frame 1
in 1
L 1
left 1
lower 2
of 1
on 3
SLOV 1
splotch 1
the 3
to 1
white 1


Mark

Current Thread