*if* you have office tools,
open the file in excel, then save again,
using something other than comma as the separator
(I found pipe to be useful).
M$ has quite regular rules for csv export,
just that they don't advertise them.
HTH DaveP.
http://www.dpawson.co.uk/java/csv2xml.html
may help
CSV files unfortunately have many conventions but no
standards. One of the conventions is that when a field
contains a comma, you put the field in quotes. I've no idea
what you are supposed to do if the field also contains
quotes. It would probably be a good idea to do some
experiments with the software that's expected to read this CSV file.
It probably does no harm to put the field in quotes
unconditionally: I assume you can tackle that on your own.
Michael Kay
http://www.saxonica.com/
> -----Original Message-----
> From: Ian Vaughan
[mailto:i(_dot_)vaughan(_at_)neath-porttalbot(_dot_)gov(_dot_)uk]
> Sent: 17 February 2005 09:02
> To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
> Subject: [xsl] XSLT and comma's in XML data
>
> 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/AddressAndPersonal
> Details">
> <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>
> --~--
>
>
--~---------------------------------------------------------
---------
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>
--~--
--
DISCLAIMER:
NOTICE: The information contained in this email and any attachments is
confidential and may be privileged. If you are not the intended
recipient you should not use, disclose, distribute or copy any of the
content of it or of any attachment; you are requested to notify the
sender immediately of your receipt of the email and then to delete it
and any attachments from your system.
RNIB endeavours to ensure that emails and any attachments generated by
its staff are free from viruses or other contaminants. However, it
cannot accept any responsibility for any such which are transmitted.
We therefore recommend you scan all attachments.
Please note that the statements and views expressed in this email and
any attachments are those of the author and do not necessarily represent
those of RNIB.
RNIB Registered Charity Number: 226227
Website: http://www.rnib.org.uk
--~------------------------------------------------------------------
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>
--~--