Deleting blank lines from text file

[Joey Martin]

I have a text file being create with the FileSystemObject. It's being
built based on results from a SQL query. All this is working fine, but
so that I have a carriage return VBCRLF at the end of each row, I have
an empty row at the end of my text file. How do I delete this last line?

Here is the end of my script:
csvText=csvText & vbcrlf
rs.movenext
loop

How should I do this? Thanks!!

 

[Evertjan.]

Joey Martin wrote on 30 aug 2005 in
microsoft.public.inetserver.asp.general:

I have a text file being create with the FileSystemObject. It's being
built based on results from a SQL query. All this is working fine, but
so that I have a carriage return VBCRLF at the end of each row, I have
an empty row at the end of my text file. How do I delete this last line?

Here is the end of my script:
csvText=csvText & vbcrlf
rs.movenext
loop

csvText = left(csvText, len(csvText)-2)

How should I do this? Thanks!!

not tested