[xsl] RE: A simple solution (Was: Re: One for tomorrow :-) )

["Daniel Newman" <daniel.newman@xxxxxxxxxxx>]

OK, thanks very much (so far) for this "simple solution". I've got the name
concatenation happening fine, but have reached a bit of a problem with
getting the next node that follows the last node with a comma in it (as was
suggested I wanted!).

The trouble is, I'm producing an HTML table, and the address [NameAddress3]
is in another row, so not sure how I need to go about getting it?

This is what I have so far:

////////////////////////////////////////////////////////////////////////////
/
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:cs="http://www.computershare.com/scripcomms/v1.0"; >
<xsl:include href="CommonFunctions.xsl" />
<xsl:output method="html" indent="yes" />

<!-- setting color values here, so can change easily -->
<xsl:variable name="LightRow" select="'#FFCC66'" />
<xsl:variable name="DarkRow" select="'#FFEBBF'" />

<xsl:template match="cs:ScripCommsMessage" >
	<xsl:apply-templates select="cs:SearchForHolderResponse" />
</xsl:template>

<xsl:template match="cs:SearchForHolderResponse" >
	<table cellpadding="2" cellspacing="0">
		<xsl:for-each select="cs:Items/cs:Item">
			<xsl:call-template name="GetTableData" />
		</xsl:for-each>
	</table>
</xsl:template>

<xsl:template name="GetTableData">
    <tr>
      <xsl:call-template name="GenerateRowColor">
	  <xsl:with-param name="Index" select="position()" />
      </xsl:call-template>
      <td width="4%" valign="top">
		<font face="Arial, Helvetica, sans-serif" size="2"><xsl:value-of
select="position()" /></font>
      </td>
      <td colspan="2" valign="top">
		<font face="Arial, Helvetica, sans-serif" size="2">
		<a href="/xml_interface/HolderInfo.asp?id={cs:HIN}" class="HolderSearch">
			<xsl:for-each select="cs:NameAddress1">
			<xsl:value-of select="."/>
				<xsl:for-each
select="following-sibling::*[substring(.,string-length(.))=',']">
					<xsl:value-of select="."/>
				</xsl:for-each>
			</xsl:for-each>
		</a><br/>
        	<xsl:value-of select="following-sibling::" /> <---- need to insert
NameAddress3 (or the next node in the 					operation above) in here?
		</font>
      </td>
      <td width="16%" nowrap="true" valign="top">
		<font face="Arial, Helvetica, sans-serif" size="2"><xsl:value-of
select="cs:HIN" /></font>
      </td>
    </tr>
</xsl:template>

</xsl:stylesheet>


-----Original Message-----
From: Dimitre Novatchev [mailto:dnovatchev@xxxxxxxxx]
Sent: 03 July 2001 20:17
To: daniel.newman@xxxxxxxxxxx
Cc: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: A simple solution (Was: Re: One for tomorrow :-) )


Daniel Newman wrote:

> My XML (I know you've all already got it :), is:
>
> <Item id="2">
> 	<HIN>G0200328400</HIN>
> 	<PostCode>EC2A 1BR</PostCode>
> 	<NameAddress1>SMITH &amp; WILLIAMSON NOMINEES</NameAddress1>
> 	<NameAddress2>LIMITED &lt;CH&gt;,</NameAddress2>
> 	<NameAddress3>10 ACACIA AVENUE</NameAddress3>
> 	<NameAddress4>HUTTINGDON HILL</NameAddress4>
> 	<NameAddress5>LONDON</NameAddress5>
> 	<NameAddress6/>
> 	<NameAddress7/>
> </Item>
>
> And my problem is, that I want to display NameAddress1, and also need to
> concat all following Nodes that end in a comma. So I need to do a:

Hi Daniel,

Actually, it is quite simple -- do note the XPath expression for all
"following
Nodes" (in this case following-sibling::*) the text of which ends in a
comma -- this
uses a combnation of the substring() and string-length() functions.

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
  <xsl:template match="/">
    <xsl:for-each select="/Item/NameAddress1">
      <xsl:value-of select="."/>
      <xsl:for-each
select="following-sibling::*[substring(.,string-length(.))=',']">
         <xsl:value-of select="."/>
      </xsl:for-each>
    </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

Hope this helped.

Cheers,
Dimitre Novatchev.




__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list