How to get the sibling node just after the context

[abha jain]

Hi,

I am transforming one xml file into another using xslt.
I have sample of xml file also:

<table:table-row>
<table:table-cell table:style-name="Title.A1" office:value-type="string" table:protected="true">
<text:p text:style-name="NEESTitle">Article Title</text:p>
</table:table-cell>
<table:table-cell table:style-name="Title.B1" office:value-type="string">
<text:p text:style-name="P4">Wipro Technology</text:p>
</table:table-cell>
</table:table-row>

Now I want Wipro Technology under <Title> tag.
I can fetch the value of Article Title because that is associated with a style name(attribute). Now I just want to take next node value.
Following is the sample code to get the value of Article Title:

<xsl:template match="/">
<Article>
<xsl:choose>
<xsl:when test="office:document-content/office:body/
office:text/table:table/table:table-row/table:table-cell/text:p[@text:style-name='NEESTitle']">
<xsl:variable name="title" select="office:document-content/office:body/
office:text/table:table/table:table-row/table:table-cell/text:p[@text:style-name='NEESTitle']"/>
<xsl:message> title value is from table <xsl:value-of select="$title"/></xsl:message>
<Article_Title>
<xsl:value-of select="$title"/>
</Article_Title>
</xsl:when>
</Article>
</xsl:template>


Please help me to get that.

[Rob Spoor]

I'll move this thread to our XML forum.

[g tsuji]

This.

<xsl:value-of select="$title/parent::*/following-sibling::table:table-cell[1]/text:p" />

[Campbell Ritchie]

And welcome to the Ranch

[abha jain]

Thank you... It worked