xsl-list
[Top] [All Lists]

XSLT and comma's in XML data

2005-02-17 02:01:58
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>&#10;</xsl:text>
<xsl:apply-templates select=".//*[not(*)]  | .//apd:*/*"/>
</xsl:template>

<xsl:template match="BuildingRecord//* | apd:*/* ">
<xsl:if test="position() &gt; 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>
--~--



<Prev in Thread] Current Thread [Next in Thread>