Retreiving substring using XSLT

nelly78 · February 27th, 2013, 11:14 AM

Hi All,

I have below XML element:

<userid>2000 2355 270427 269770</userid>

Using xslt I want to retrieve only '270427' string.

Could you please tell me how to do that.

Regards
Yunus

Martin Honnen · February 27th, 2013, 11:35 AM

Assuming XSLT 2.0

Code:

<xsl:template match="userid">
  <xsl:value-of select="tokenize(., ' ')[3]"/>
</xsl:template>

nelly78 · February 27th, 2013, 12:18 PM

Hi Martin,

Thanks for your reply. Sorry forgot to mentioned I am using XSLT 1.0.

Could you please help for 1.0.

Like to add one more thing, there can be more then four strins in the userid element i.e. <userid>2000 2355 22355 270427 269770</userid>

But I always want to retrieve second last string i.e '270427'.

Many thanks for your help.

-Nelly

nelly78 · February 28th, 2013, 07:12 AM

Hi All,

Could someone please give any idea.

-Nelly

Martin Honnen · February 28th, 2013, 07:25 AM

Well which XSLT 1.0 processor do you use? Does it support an extension function like http://www.exslt.org/str/functions/tokenize/index.html? That could be used in a similar way as the XSLT 2.0 tokenize.
As for access the second last, you would use

Code:

<xsl:variable name="tokens" select="tokenize(., ' ')"/>
<xsl:value-of select="$tokens[last() - 1]"/>

respectively a similar extension function.

If you don't have an extension function then use a named, recursive template that does the tokenization. http://www.dpawson.co.uk/xsl/sect2/N...tml#d10127e349 should give you an idea.

mhkay · February 28th, 2013, 07:29 AM

Write a recursive template that accepts the string as input, after doing normalize-space(). Use substring-after() to get the "tail", i.e. the content after the first space. If the tail contains a space, recurse passing the tail as the argument. Otherwise, use substring-before() to get the the content before the first space, and that's your answer.