RE: [xsl] XSLT and comma's in XML data

Subject: RE: [xsl] XSLT and comma's in XML data
From: "Ian Vaughan" <i.vaughan@xxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 17 Feb 2005 15:44:46 -0000
If you look at the first example output this is how it is coming back

UniqueRecordID, 2434,
RegistrationNumber, 0203,
RegisteredName, Bloggs,
Address1, Bank
Address2, Street
PostCode, Town
DateComplete, TR43 7TY
DescriptionOfWorkItems, 20/01/2005,Shower,Dwelling house,

As you can see because the data for the Address 1 Bank,Street had a
comma it inserts Bank into Address 1 and Street into Address 2 thus
making other fields hold incorrect data such as PostCode, DateComplete
and Description of Work Items

I would like to generate Bank,Street in the CSV as it is in the XML file
but ensure that it matches the relevant heading in the example above
Address 1.

-----Original Message-----
From: David Carlisle [mailto:davidc@xxxxxxxxx]
Sent: 17 February 2005 10:30
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [xsl] XSLT and comma's in XML data

>Which is interfering with the following XSLT

nothing. The comma acts just like any other character in XSLT.
What Michael meant is that you must check what output you want to
generate in this case.
If you have comma separated fields but one of the fields contains a
comma do you want to generate ... ,Bank\, Street, ...
... ,"Bank, Street", ...
or what?
Currently you generate
... ,Bank, Street, ...
which isn't a problem for XSLT but causes errors in your subsequent

We can't help as we don't know what conventions your program needs to
get a comma into a field.


This e-mail has been scanned for all viruses by Star. The service is
powered by MessageLabs. For more information on a proactive anti-virus
service working around the clock, around the globe, visit:

Current Thread