reading text file using VBSCRIPT

[blakeph]

hello everyone!

i have a VBSCRIPT that will read the last 6 entries (from bottom to top) of a text file, and then would save the result into a separate text file called "result.txt", and the code look like this:

PHP Code:

Dim arrFileLines()
i = 0
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("d:\backup\test.txt", 1)

' create the output file here
Set objoutputFile = objFSO.CreateTextFile("d:\backup\result.txt")

Do Until objFile.AtEndOfStream
Redim Preserve arrFileLines(i)
arrFileLines(i) = objFile.ReadLine
i = i + 1
Loop
objFile.Close
For l = Ubound(arrFileLines)-5 to Ubound(arrFileLines)

' write the output to the file
objoutputFile.writeline arrFileLines(l)
Next

'Close the output file
objoutputFile.close


am trying to modify the code to read only the second line (from bottom to top) of the text file and then save it to separate text file, but i could'nt do it, any help would be appreciated. thanks!

[JPnyc]

Well I think you should be able to reference it with the len function, i.e.:

len(arrFileLines()) - 2

Basically I think that will give you the 2nd to last line

[blakeph]

thanks JPnyc, i got it using your suggestions.

[JPnyc]

Cool! I'm on a roll with vbscript and I never studied it

[keep smilling]

i would like to know how to parse a rar file into .csv file using vbscript