folks
how can I extract specific data from other logs into another log file but only after a specific timestamplis met i.e. i want to extract the values
"system#notboundexception" Or "Successfully connected" from log 1 and log 2 but only if they are logged within the last 24 hours from now
log 1
[14/03/14 16:04:51:985 GMT xxxxxxxxxxxx eeeeeeeeeeeeeee
system#notboundexception
[15/03/14 10:04:51:985 GMT xxxxxxxxxxxx eeeeeeeeeeeeeee
system#notboundexception
log 1
[12/03/14 16:24:51:985 GMT xxxxxxxxxxxx eeeeeeeeeeeeeee
system#notboundexception
[15/03/14 10:04:51:985 GMT xxxxxxxxxxxx eeeeeeeeeeeeeee
Successfully connected
output.log should only show the log entries from either log 1 /2 on over the last 24 hours (being today)
how can I achieve this?
Below is my code to extract the values from the logs , I need help in assuring only todays records are extracted only
Dim objFSO
Dim objFile
Dim objOut
Set objFSO = CreateObject("Scripting.FileSystemObject")
Const intForReading = 1
'create output file
strOutputName = "output.txt"
Set objOut = objFSO.GetFolder(strFolder).CreateTextFile(strOutputName, True)
'for each file in directory
For Each objFile In objFSO.GetFolder(strFolder).Files
'if its a log file
If Right(LCase(objFile.Name), 4) = ".log" Then
'open log file
Set objLogFile = objFSO.OpenTextFile(objFile.Path, intForReading, False)
'loop thorugh log file
Do While Not objLogFile.AtEndOfStream
strData = Replace(objLogFile.ReadLine, ",", "")
'replace(var,",","")
If InStr(strData, "system#notboundexception") Or InStr(strData, "Successfully connected") Then objOut.WriteLine strData & ", " & objFile.Name & ", " & Date & ", " & Time & ""
Loop
objLogFile.Close
Set objLogFile = Nothing
End If
Next
objOut.Close
all help will do