tags:

views:

31

answers:

1

How to convert XML to CSV (to be shown in Excel file) using XSLT?

Provided XML value itself contains comma, e.g.

<name>The,Bad Boy</name>

My logic considers "The" & "Bad boy" as separate values as it goes in different columns after opening in Excel file.

+2  A: 

It's not that this type of question would not have been answered before:

By the way, "CSV" does not mean that values cannot contain commas or must be separated by commas.

Excel can understand CSV that is separated by other characters than comma (tab, for example), and values that contain the separator can be enclosed in quotes.

Tomalak