I have a problem in csv tranformation using xslt from xml.
The problem is the city string is having a comma inside like "huntington,ny" and when generated into a csv, its splitted into two cells and got messed up.
If anyone could let me know how to escape this comma from city and fit into a single cell of the csv file.

<xsl:value-of select="Info/city"/>
<xsl:value-of select="','"/>

Thanks in advance.

That's why CSV often puts quotes around fields. But then you have to escape the quote if the field has a quote as one of its characters. How do you wish to escape the comma?

--

Joe (Microsoft MVP - XML)

we don't have control over the source xml, but it will great if we can do something at the xslt to treat this field a little special by allowing to put quote or somenthing and at the output file should go with properly in a single field. thanks.

I don't follow, can you show an example of the output you'd like if the field has a comma in it?

--

Joe (Microsoft MVP - XML)

output can be something like this will be fine:
user1,'huntington,ny',11717,US

So what wrong with the following:

<xsl:value-of select="Info/username"/>,"<xsl:value-of select="Info/city"/>",<xsl:value-of select="Info/zipcode"/>,<xsl:value-of select="Info/state"/>

/- Sam Judson : Wrox Technical Editor -/