Apple

On 08-04-30, at 10:33, Jim Skibbie wrote:

I have an XML file that has multiple repeating <ROW> tags. I’m parsing it using the AppleScript XMLLib OSAX and need to find the text of the Value element in the Row element where the value of the IDNoSetItemParent is 6353368.

I’m using the commands:

    set theDoc to XMLOpen XMLfile
   set the_root to XMLRoot theDoc
   set CustomFieldPath to XMLXPath the_root with "ROW/IDNoSetItemParent[. = \"6353368\"]"

Which gets me to here:         <IDNoSetItemParent>6353368</IDNoSetItemParent>

I need to get the text of the Value element that is three siblings below that, so I’m looping the command:

        repeat with i from 1 to 3
            set CustomFieldPath to XMLNextSibling CustomFieldPath
       end repeat
        set setValue to (XMLGetText item 1 of CustomFieldPath)

Does anyone know if there is a simpler XMLXPath command that works with XMLLib to go down three siblings from the first ? I tried following-sibling, but that does not yield an XMLRef

I'm guessing what you need is "first Value after matched IDNoSetItemParent":

<?xml version="1.0"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="//ROW">

<xsl:value-of select="IDNoSetItemParent[.='6353368']/following-sibling::Value[position()=1]"/>

</xsl:template>

</xsl:stylesheet>

Philip Aker

echo email@hidden@nl | tr a-z@. p-za-o.@

Sent from my SE/30

References:
	>XMLNextSibling is there an easier way (From: Jim Skibbie <email@hidden>)