Element extraction

Neal · March 21st, 2007, 04:01 AM

Hi,

Version 1.0

I need to identify (and extract) '0006509602/01' from the following code:

[u]XML

Code:

<OrderLine LineNumber="1">
  <LineReference ReferenceType="Contract Number" AssignedBy="Buyer">0006509602/01</LineReference>

The OrderLine/LineNumber ('1') may be incremented throughout the full XML, which is why I have referred to the 'position()' in the follwing XSL. The XXXXXXX output, is the string that I need.

[u]XSL

Code:

<xsl:template name="OrdLine">
  <xsl:for-each select="*//OrderLine/@LineNumber">
    <xsl:element name="OrderLine">
      <xsl:attribute name="LineNumber"><xsl:value-of select="$strLineNo"/></xsl:attribute>            
    <xsl:element name="LineReference">
      <xsl:attribute name="ReferenceType">Contract Number</xsl:attribute>
            <xsl:attribute name="AssignedBy">Buyer</xsl:attribute>
              <xsl:value-of select="XXXXXXX"/>            
        </xsl:element>
    </xsl:element>
  </xsl:for-each>    
</xsl:template>

I have tried various methods, but have been unsuccessful.

[u]Methods
1.

Code:

.//OrderLine[@LineNumber='position()']/LineReference[@ReferenceType='Contract Number'][@AssignedBy='Buyer']

2.

Code:

.//OrderLine[@LineNumber='position()']/LineReference/[@AssignedBy='Buyer']

3.

Code:

.//OrderLine[@LineNumber='position()']//[@AssignedBy='Buyer']

[u]NOTE
'LineReference' is one of several child-nodes of 'OrderLine'.

Thanks in advance,

Neal

A Northern Soul

joefawcett · March 21st, 2007, 04:14 AM

It's hard to say, your template matches OrdLine rather than OrderLine but that maybe a typo.
If you have a template matching OrderLine then to retrieve the desired string you need:

Code:

<xsl:value-of select="LineReference"/>

I'm not sure where the LineNumber attribute comes into play.
If this doesn't help you need to show the XML source and the desired output and the mapping between them.

--

Joe (Microsoft MVP - XML)

Neal · March 21st, 2007, 04:35 AM

Hi,

The 'OrdLine' template is fine. It is referenced and accessed (I confirmed this by debugging).

[u]XML

Code:

<Order>
  <OrderLine LineNumber="1">
    <LineReference ReferenceType="Contract Number" AssignedBy="Buyer">0006509602/01</LineReference>
    <LineReference ReferenceType="Contract Number" AssignedBy="Supplier">ppersupref</LineReference>
    <ProductReference ReferenceType="Assigned By Buyer">496500</ProductReference>
    <ProductDescription Type="Defined by Buyer">REGULATOR 1</ProductDescription>
    <ProductValues>
      <Quantity QuantityType="Order Quantity" QuantityUOM="Unit">1000</Quantity>
      <UnitPrice PriceUOM="Unit">0.59</UnitPrice>
    </ProductValues>
  </OrderLine>
</Order>

The Value-of Select 'LineReference' also returns blank.

Neal

A Northern Soul

joefawcett · March 21st, 2007, 04:53 AM

Well you need to show the full XML then as there's no OrdLine element showing so I can't tell what the correct path should be. Answering questions is easier if the poster follows the guidelines on the XSLT forum, where this question should really be :)

--

Joe (Microsoft MVP - XML)