From DB to excel using ASP - display probs 1

[doorbreaker]

Hi,

I've been asked to provide a CSV with a whole load of products, their prices and descriptions from our db.

After I've exported it using server.createobject ("scripting.filesystemobject") and try and open in excel the data is all over the place.

I am assuming this is because of line breaks and suchlike.

Does anyone know of anyway to clean up the data (its the description field) so that each product is displayed on just one line in the csv?

I have been using:

Description = replace(Description,"<br>","")

to remove certain html elements but the problem remains.

Thanks for any help or suggestion on this matter.

Chris

 

[FesterSXS]

it is more likely that your description fields are full of line breaks and carriage returns.

try this instead/as well:

Description = Replace(Description, vbcrlf, "")

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[doorbreaker]

Brilliant - thanks very much - worked a treat.

 

[FesterSXS]

glad to help

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation