Remove a carriage return from a text document

[collierd]

Hello

Does anybody know if the following is possible:

I have a number of text files generated monthly (i.e. A123450001.TXT)
Each of these text files are generated from a data extract into text format
Problem is, it keeps adding an extra carriage return at the end
Can vbscript be used to remove the last line only from a txt file?
If so, how

Thanks

Damian.

 

[Targol]

Yes, you can do it but it's a little "heavy" :
- rename your text file as .old
- open it as textstream (with filesystem object's method "OpenTextFile" wich returns a textStream object).
- Create a new text file (with .old's original name) with the filesystem object's method "CreateTextFile".
- read all lines form .old to write them to new .txt using "readLine" and "WriteLine" methods of TextStream object.
- "Forget" to write last read line. Water is not bad as long as it stays out human body ;-)

 

[collierd]

Thanks
That makes sense
I'll give that method a go