I am having a problem with my XML a snippet of which is shown below
<PropertyAddress>
<apd:A_5LineAddress>
<apd:Line>Bank, Street</apd:Line>
<apd:Line />
<apd:Line />
<apd:Line>Town</apd:Line>
<apd:PostCode></apd:PostCode>
</apd:A_5LineAddress>
</PropertyAddress>
...........................etc
The problem I am finding is that in the XML some fields such as
<apd:Line> sometimes has data that contains a comma such as
'Bank,Street'
Then when parsing this through the XSLT it is locating the comma
seperating 'Bank,Street' and splitting up the data
Any ideas on a solution would be most helpful
This is the XSLT
----------------------------------------------------------
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:apd="http://www.govtalk.gov.uk/people/AddressAndPersonalDetails">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:text>UniqueRecordID, RegistrationNumber, RegisteredName, Address1,
Address2, Address3, Address4,PostCode, DateComplete,
DescriptionOfWorkItems
</xsl:text>
<xsl:apply-templates select="//BuildingRecord"/> </xsl:template>
<xsl:template match="BuildingRecord">
<xsl:text> </xsl:text>
<xsl:apply-templates select=".//*[not(*)] | .//apd:*/*"/>
</xsl:template>
<xsl:template match="BuildingRecord//* | apd:*/* ">
<xsl:if test="position() > 1 ">,</xsl:if>
<xsl:value-of select="normalize-space(.)"/> </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>
--~--