Re: [xsl] How to fetch desired data
by rob Jackson other posts by this author
Dec 30 2005 11:44PM messages near this date
Re: [xsl] How to fetch desired data
|
Re: [xsl] How to fetch desired data
& XSLT 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@[...].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 exceptionne
ls 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@[...].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@[...].com>
--~--
Thread:
rob Jackson
James Fuller
rob Jackson
Florent Georges
rob Jackson
Florent Georges
James Fuller
Florent Georges
|