[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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@xxxxxxxx> 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 : tiliphonez moins cher avec Yahoo! Messenger ! Dicouvez les tarifs exceptionnels pour appeler la France et l'international. > Tilichargez sur http://fr.messenger.yahoo.com
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|