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.

in my codes, I use Replace to check for ',' and replace it with ';'.

something like this,
strLine = strLine & Replace(Item,",",";") & ","
where Item is the record from the recordset.


strLine is then added to CSV file by Scripting.FileSystemObject's WriteLine.