To split the string into two in XPath

Question

My XML source looks like:

<span class="char-style-override-6">Breast Problems (Female and Male)   511</span>

and I have a template match for it

<xsl:template match="span" mode="table">

My difficulty now is within this template match, I need to create two tags, the first will contain the string "Breast Problems (Female and Male)", while the second only contain the page number "511".

I just don't know how to do this substring split, in order to differentiate text and numeric value.

Answer 1

An XSLT 2.0 solution:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" indent="yes"/>
    <xsl:template match="/">
        <output>
            <xsl:apply-templates mode="table"/>
        </output>
    </xsl:template>
    <xsl:template match="span" mode="table">
        <xsl:variable name="split" select="replace(., '.*\s(\d+)$', '$1')"/>
        <string><xsl:value-of select="normalize-space(substring-before(., $split))"/></string>
        <number><xsl:value-of select="$split" /></number>
    </xsl:template>
</xsl:stylesheet>

applied to

<?xml version="1.0" encoding="UTF-8"?>
<root>
    <span class="char-style-override-6">Breast Problems (Female and Male)   511</span>
</root>

gives

<?xml version="1.0" encoding="UTF-8"?>
<output>
    <string>Breast Problems (Female and Male)</string>
    <number>511</number>
</output>