Readline txt file, read the last line

[AvN]

Hi, I am new to Autoit. I have to open a txt file where I have data, read the last line; and in the last line read the element of column 6.

$file= FileOpen ("C:Test.txt",0)

If $file = -1 Then

Beep(500, 700)

MsgBox(16, "Error", "Unable to open file.")

Exit

EndIf

$last_line = FileReadLine ($file, -1)

MsgBox (0,"Finish reading", $last_line, 1)

Sleep (200)

From here it gives me the last line where I have columns and rows, so I have to extract the data in column 6.

How I do it. I tried to open the file with excel, but as you can imagine the last line of excel is always empty...

Your help will be appreciated.

AvN

[andygo]

please post a sample how your last line could look like.... how are the columns seperated...

Edited September 15, 2009 by andygo

[Mecrazycoder]

Hi, I am new to Autoit. I have to open a txt file where I have data, read the last line; and in the last line read the element of column 6.

$file= FileOpen ("C:Test.txt",0)

If $file = -1 Then

Beep(500, 700)

MsgBox(16, "Error", "Unable to open file.")

Exit

EndIf

$last_line = FileReadLine ($file, -1)

MsgBox (0,"Finish reading", $last_line, 1)

Sleep (200)

From here it gives me the last line where I have columns and rows, so I have to extract the data in column 6.

How I do it. I tried to open the file with excel, but as you can imagine the last line of excel is always empty...

Your help will be appreciated.

AvN

I think you can do it using StringSplit function by specifying delimiters as space or tab.

[AvN]

please post a sample how your last line could look like.... how are the columns seperated...

Here is how the last line look like (exactly):

18:23:00 -39.0 -39.2 -38.4 -38.8 -39.2 -39 -41

So the question is from this line, how can I make the script to read just the data in colum 6 (which is-39.2). the first column is the time.

This is easily done in Autohotkey by using A-index and A-Loopfield, but I can't see how to doit in Autoit.

Thank you for your help.

[PsaltyDS]

$avParts = StringSplit($sLine, " ")
ConsoleWrite("Col 6 = " & $avParts[6] & @LF)

Dog ate your help file?

[AvN]

$avParts = StringSplit($sLine, " ")
ConsoleWrite("Col 6 = " & $avParts[6] & @LF)

Dog ate your help file?

Hi I tried $avParts = StringSplit($sLine, " "), it is not accepting " " but it is accepting "" (without space). But again in this case it reading just 1 character at a time. for eg. $avParts[6]is ":". So it is starting at 18:23:00, the 6th character here is ":"

But I want it to read a value for eg. -39.2 (at once).

I am trying to open the file with excel and real cells, but how to get the last line in excel. The difficulty is that my data may stop at line 200 of excel sheet but the same sheet may have 2000 lines. How to make the script stop reading where at the last line of my data and not at the last line of excel itself?

More help needed.

Edited September 15, 2009 by AvN

[PsaltyDS]

Hi I tried $avParts = StringSplit($sLine, " "), it is not accepting " " but it is accepting "" (without space). But again in this case it reading just 1 character at a time. for eg. $avParts[6]is ":". So it is starting at 18:23:00, the 6th character here is ":"

But I want it to read a value for eg. -39.2 (at once).

More help needed.

Back to the help file!

The second parameter of StringSplit() is the delimiter. It looked to me like a space was the delimiter. If not, replace it with the correct delimiter (i.e. "," or @TAB). If you pass a null delimiter(i.e. "") it splits out every character, exactly as the help file says.

StringRegExp() could also split on any white space character, but you don't sound like you're ready to go there yet.

[AvN]

Back to the help file!

The second parameter of StringSplit() is the delimiter. It looked to me like a space was the delimiter. If not, replace it with the correct delimiter (i.e. "," or @TAB). If you pass a null delimiter(i.e. "") it splits out every character, exactly as the help file says.

StringRegExp() could also split on any white space character, but you don't sound like you're ready to go there yet.

Thanks a lot. @TAB works. You are the man.

Edited September 15, 2009 by AvN