xsl-list
[Top] [All Lists]

Re: How to fetch desired data

2005-12-30 06:07:15
rob Jackson wrote:

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>

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

    <...><xsl:value-of select="$before"/></...>
    <state><xsl:value-of select="$state"/></state>
    <zip><xsl:value-of select="$zip"/></zip>

--drkm



















        

        
                
___________________________________________________________________________ 
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs 
exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com

--~------------------------------------------------------------------
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>