SSDN - Nested XML value

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

chelsea drennan

Subject: Nested XML value
Author: chelsea drennan
Date: 17 Jun 2009 11:32 AM

Hi Forum,

I am currently working to extract a 'buried' value that is included in XML tags. This is the format of the value that I need:

<wd:BizSite>
<wd:BizSiteUsage_OFFC wd:Descriptor="BOS">
<wd:ID wd:type="WID">XXXX</wd:ID>
<wd:ID wd:type="Business_Site_Usage_ID">BOS</wd:ID>
</wd:BizSiteUsage_OFFC>
</wd:BizSite>

I am trying to extract the 'Business_Site_Usage_ID', using the XSL:value-of option, but since it is buried within the xml tag, I have not been able to get the value.

Here are a couple of options that have not worked successfully:
<xsl:value-of select="wd:BizSite/wd:BizSiteUsage_OFFC/wd:ID/wd:type/wd:Business_Site_Usage_ID"/>

<xsl:value-of select="wd:BizSite/wd:BizSiteUsage_OFFC/wd:type/wd:Business_Site_Usage_ID"/>

<xsl:value-of select="wd:BizSite/wd:BizSiteUsage_OFFC/wd:type"/>

Does anyone have any recommendations as to how I can extract that second value only from the tags? I have been able to extract the 1st 'XXXXX' value, but not the second value of 'BOS'.

Thanks for any assistance.

(Deleted User)

Subject: Nested XML value
Author: (Deleted User)
Date: 18 Jun 2009 08:35 AM
Originally Posted: 18 Jun 2009 08:34 AM

<xsl:value-of select="wd:BizSite/wd:BizSiteUsage_OFFC/wd:ID[@wd:type='Business_Site_Usage_ID']"/>

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.