xsl-list
[Top] [All Lists]

Re: How to fetch desired data

2005-12-30 06:05:18
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

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>