XML to CSV Conversion

[alok156190]

Hi all, I am new to xml and xsl conversion . I am facing the following problem:

the data in my xml is like


<name>john,tom,harry</name>

but in excel sheet the data instead of coming in same column,came in as all in different columns (john|tom|harry ).
Kindly anyone tell me the way of dealing with commas in XML.

Please please please.

[dorinbogdan]

If using CSV file as output then you should replace the commas in each <name> element with other character or with a blank space.
It's easy by using the replace XSL 2.0 function.

[alok156190]

Replace function is not working sir can you please tell me any other mathod

If using CSV file as output then you should replace the commas in each <name> element with other character or with a blank space.
It's easy by using the replace XSL 2.0 function.