Hi
I would like to separate the data listed in the BulletPoints section of my
XML (see below). Fortunately there is an * symbol seperating each line of
data that I need. This data is then used to fill a predertimed set of Rows
for each tag so I will need to create tags for each new line created.
If anyone could point me in the right direction it would be much
appreciated.
James
XML
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!--RT Generated XML file-->
<property>
<Price>125950.00</Price>
<Unit />
<Building />
<StreetNumber>55</StreetNumber>
<StreetName>Priors Drive</StreetName>
<Village>Old Catton</Village>
<Town>NORWICH</Town>
<County>Norfolk</County>
<PostCode>NR6 7LJ</PostCode>
<BulletPoints><![CDATA[Entrance Lobby * Kitchen * Lounge * 2 Bedrooms *
Bathroom * Gas Fired Radiator Central Heating * Sealed Unit Double Glazing
* Gardens * Car Parking * Cul-de-Sac position * (Ref: 46479/MH)
]]></BulletPoints>
<Status>Under offer</Status>
</property>
XSL
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="xml" indent="yes"/>
<xsl:strip-space elements="*"/>
<xsl:output method="xml" />
<xsl:template match = "/" >
<DATAPACKET Version="2.0">
<xsl:call-template name="CDSMetaData"/>
<ROWDATA>
<xsl:apply-templates/>
</ROWDATA>
</DATAPACKET>
</xsl:template>
<xsl:template name="CDSMetaData">
<METADATA>
<FIELDS>
<FIELD attrname="Price" fieldtype="string" WIDTH="255" />
<FIELD attrname="Unit" fieldtype="string" WIDTH="255" />
<FIELD attrname="Building" fieldtype="string" WIDTH="255" />
<FIELD attrname="StreetNumber" fieldtype="string"
WIDTH="255" />
<FIELD attrname="StreetName" fieldtype="string" WIDTH="255"
/>
<FIELD attrname="Village" fieldtype="string" WIDTH="255" />
<FIELD attrname="Town" fieldtype="string" WIDTH="255" />
<FIELD attrname="County" fieldtype="string" WIDTH="255" />
<FIELD attrname="PostCode" fieldtype="string" WIDTH="255" />
<FIELD attrname="BulletPoints" fieldtype="string"
WIDTH="255" />
<FIELD attrname="Status" fieldtype="string" WIDTH="255" />
</FIELDS>
</METADATA>
</xsl:template>
<xsl:template match="property">
<xsl:variable name="Price" select="Price" />
<xsl:variable name="Unit" select="Unit" />
<xsl:variable name="Building" select="Building" />
<xsl:variable name="StreetNumber" select="StreetNumber" />
<xsl:variable name="StreetName" select="StreetName" />
<xsl:variable name="Village" select="Village" />
<xsl:variable name="Town" select="Town" />
<xsl:variable name="County" select="County" />
<xsl:variable name="PostCode" select="PostCode" />
<xsl:variable name="BulletPoints" select="BulletPoints" />
<xsl:variable name="Status" select="Status" />
<ROW Price="{$Price}" Unit="{$Unit}" Building="{$Building}"
StreetNumber="{$StreetNumber}" StreetName="{$StreetName}"
Village="{$Village}"
Town="{$Town}" County="{$County}" PostCode="{$PostCode}"
BulletPoints="{$BulletPoints}" Status="{$Status}" />
</xsl:template>
</xsl:stylesheet>
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--