Read Second Line from last with text

[Vikramjeet]

I need help with reading the second last line with text from a .log file. Can some provide a simple script...Thanks

[Melba23]

Vikramjeet,

Read the file into an array - extract the penultimate element.

M23

[Danp2]

Some good discussion here --

 

[mikell]

My 2 cents, for the fun. This one doesn't exist in the topic mentioned above 

Msgbox(0,"", StringRegExpReplace(FileRead("test.txt"), '(?ms).*(^\N+$)\s*(?1)\s*\z', "$1") )

Edit
For the fun, version 2     
This one returns the n'th non-empty last line
If n is greater than the number of non-empty lines, it returns the first non-empty line
If the file is empty or blank, returns 0

Msgbox(0,"", _UmpteenthLastLine("test.txt", 3))

Func _UmpteenthLastLine($file, $n)
   Local $txt = FileRead($file)
   If not StringRegExp($txt, '\S') Then Return 0
   Return StringRegExpReplace($txt, '(?ms).*?(^\N*\S\N*$)\s*(?:(?1)\s*){0,' & $n-1 & '}\z', "$1")
EndFunc

 

Edited October 14, 2018 by mikell

[Vikramjeet]

Thank you MVP. The Regular expression is perfect. Can you please help modify this script to read the 2nd last line and if the value in the second last line = "INVALID" then do something.....Thanks. Appreciate your help

[mikell]

  On 10/15/2018 at 2:40 AM, Vikramjeet said:

Can you please help modify this script to read the 2nd last line ....

Expand  

That's what it does.

  On 10/15/2018 at 2:40 AM, Vikramjeet said:

.... and if the value in the second last line = "INVALID" then do something

Expand  

This is a If/Then/EndIf condition including a basic string comparison . Look at the helpfile for Operators