Re: [xsl] How to fetch desired data

Subject: Re: [xsl] How to fetch desired data
From: James Fuller <jim.fuller@xxxxxxxxxxxxxx>
Date: Fri, 30 Dec 2005 14:05:18 +0100
rob Jackson wrote:

>Hi Jim,
>
>Thanks for your reply.
>'<xsl:' is prefixed just for example purpose. Pls ignore it.
>
>By using substring-before comma I am able to get
><city>Charles Army Street; Boston</city>
>
>but substring-after comma gives me 'Ma 01779'
>
>I want this also to be split as
><state>Ma</state>
><zip>01779</zip>
>  
>

now define substring func with whitespace as your delimiter...

<xsl:variable name="string" select="'Ma 01779'"/>

<xsl:variable name="state" select="substring-before($string,' ')"/>

<xsl:variable name="zip" select="substring-after($string,' ')"/>

gl, Jim Fuller

Current Thread