Re: How to fetch desired data

Hi Florent,

Thanks for the solution but still there is some problem.
If you see my source xml which is like

<xsl:address>Charles Army Street; Boston, Ma 01779</xsl:address>

which has got space after comma and before 'Ma'. So it is
displaying the result as
<state></state>
<zip>Ma 01779</zip>

I have modified your code to get the desired result.

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


-Rob


   <MyCity><xsl:value-of select="$before"/></MyCity>
   <MyState><xsl:value-of select="$state"/></MyState>
   <MyZip><xsl:value-of select="$zip"/></MyZip>


On 12/30/05, Florent Georges <darkman_spam(_at_)yahoo(_dot_)fr> wrote:
> 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>
> --~--
--~------------------------------------------------------------------
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>
--~--