Simpleton requires help re creating a .csv file

[lloydi]

OK, I know how to use ASP to create and write into a .CSV file on the server, but I have a small problem. Every time I write to the file I am adding new lines each time. I don't know how to wipe the previous contents out, and I thought this is probably a no-brainer for you guys ...

So, I'm looking either to delete the file at the start of the process and start from scratch or

* open the file
* wipe all contents from file
* write to the newly cleaned file

Hope someone can help.

[nickc]

Instaed of opening the file, create a new one irrespective as to whether it already exists which will wipe it clean. Hope this helps.

Nick

[lloydi]

Instaed of opening the file, create a new one irrespective as to whether it already exists which will wipe it clean. Hope this helps.

Nick

Actually, I thought that was what I was doing. Here's what I have:

<%
Set fs = Server.CreateObject("Scripting.FileSystemObject")
Set a = fs.OpenTextFile(server.MapPath(/data/data.csv"),8, true)
strCSV = replace (strCSV,"<br />",chr(13))
a.WriteLine(strCSV)
%>

[MarcusJT]

This is a perfect example of why you should use enumerated constants instead of values.

Here's the offending line with the relevant value replaced with the corresponding enumerated constant.... get it now?:

Set a = fs.OpenTextFile(server.MapPath(/data/data.csv" ),ForAppending, true)

For more info (i.e. the value you need for writing WITHOUT appending) consult your scripting documentation...

hint hint