ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> xsl-list
xsl-list
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

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved