Hi All,

I want to send some data from my asp page into a spreadsheet.Fot that I am doing

response.ContentType="application/csv"
Response.AddHeader "Content-Disposition", "filename=mydata.csv;"

But the problem I am facing is that, in one of the fields which I want to send to spreadsheet contain commas.Using comma as delimiter creates problem as it splits in between.How can I change the delimiter for the file within an asp page.

Or is there any other solution.


Please help.

I am not sure how to do this in ASP per se, but you could take that field and split it on the comma in an array and send both pieces with a space or period instead of a comma.

I am not sure how to change the delimiter. Sorry.

mmcdonal