Parse Data in log

[gr1fter]

hello,

I have a log file that I am trying to get data from:

Bytes : 259.90 m 122.27 m 137.63 m 0 0 0

Bytes : 100.00 m 96 m 137.63 m 0 0 0

Bytes : 3.90 m 2.27 m 137.63 m 0 0 0

Bytes : 59.90 m 122.27 m 137.63 m 0 0 0

Bytes : 200.90 m 32.27 m 137.63 m 0 0 0

Bytes : 350.70 m .27 m 137.63 m 0 0 0

How would i go about reading only the second set of "m" numbers:

I want to return from above:

122.27 m

96 m

2.27 m

122.27 m

32.27 m

.27 m

so far i only been able to read each line using FileReadLine, but i do not know how to read the second set of numbers because the data / spaces is dynamic and never the same so not quite sure how to capture that info.

any help would be greatly appreciated. Thanks,

[jdelaney]

This works, but there must be better ways to do it

; read in a line

$stest = "Bytes : 259.90 m 122.27 m 137.63 m 0 0 0"

; split on the 'm'

$asTest = stringsplit ( $stest, "m" )

; use the second

$sNeededString = StringReplace ( $asTest[2], " ", "" ) & " m"

; display

msgbox ( 4096, "test", $sNeededString )

[Jos]

Something like this:

Global $INPUT[6] = ["259.90 m 122.27 m 137.63 m  0  0  0","100.00 m 96 m 137.63 m  0  0  0","3.90 m 2.27 m 137.63 m  0  0  0","59.90 m 122.27 m 137.63 m  0  0  0","200.90 m 32.27 m 137.63 m  0  0  0","350.70 m .27 m 137.63 m  0  0  0"]
For $X = 0 To UBound($INPUT)-1
    ConsoleWrite($x & "  Record:" & $INPUT[$x] & @crlf)
    $Result = StringRegExp($INPUT[$x],"(.*?)m",3)
    ConsoleWrite("  Result:")
    For $i = 0 To UBound($Result) - 1
        ConsoleWrite($i & "=" & $Result[$i] & "    ")
    Next
    ConsoleWrite(@CRLF)
    ConsoleWrite(@CRLF)
Next

[BrewManNH]

Here's my entry

$File = FileOpen("text.txt") ; change to your file name
While 1
    $Text = FileReadLine($File)
    If @error = -1 Then ExitLoop
    $Start = StringInStr($Text, "m")
    $Text2 = StringMid($Text, $Start + 2, StringInStr($Text, "m", 0, 2) - $Start)
    ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $Text2 = ' & $Text2 & @CRLF & '>Error code: ' & @error & @CRLF) ;### Debug Console
WEnd

[Guest]

This is the best way.

#include <Array.au3>
$Itext = "Bytes : 259.90 m 122.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 100.00 m 96 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 3.90 m 2.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 59.90 m 122.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 200.90 m 32.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 350.70 m .27 m 137.63 m  0  0  0"
$FFFF = StringRegExp($Itext, '(?i)Bytes : .*?m(.*?m)', 3)
_ArrayDisplay($FFFF)

If you want to read from a file use the below code.

#include <Array.au3>
$Text = FileRead(@ScriptDir&"logN.txt")
$FFFF = StringRegExp($Text, '(?i)Bytes : .*?m(.*?m)', 3)
_ArrayDisplay($FFFF)

Edited February 15, 2012 by Guest

[BrewManNH]

This is the best way.

#include <Array.au3>
$Itext = "Bytes : 259.90 m 122.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 100.00 m 96 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 3.90 m 2.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 59.90 m 122.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 200.90 m 32.27 m 137.63 m  0  0  0" & @CRLF & _
"Bytes : 350.70 m .27 m 137.63 m  0  0  0"
$FFFF = StringRegExp($Itext, '(?i)Bytes : .*?m(.*?)m', 3)
_ArrayDisplay($FFFF)

Why is that the "best" way? If all of the ways work equally that is.

[Guest]

Why is that the "best" way? If all of the ways work equally that is.

Because it is the cleanest.

[BrewManNH]

Because it is the cleanest.

Define cleanest, because that's an ambiguous phrase that means nothing out of context.

I know my method will be slower due to reading from a file, but using the other codes and reading from the same file, the speeds are relatively the same rather than pre-loading the array/string in the script. So, it's not a question of speed in this case. So I was curious as to what the "best" and "cleanest" mean in the context of code. Yes, it's one line compared to several, but that one line still takes just as long as reading a line at a time.

[Guest]

Define cleanest, because that's an ambiguous phrase that means nothing out of context.

I know my method will be slower due to reading from a file, but using the other codes and reading from the same file, the speeds are relatively the same rather than pre-loading the array/string in the script. So, it's not a question of speed in this case. So I was curious as to what the "best" and "cleanest" mean in the context of code. Yes, it's one line compared to several, but that one line still takes just as long as reading a line at a time.

I don't understand what is your problem with me. But let me define you what i meant my the "Best", is that my code is fast when it comes to parsing data.

I also did a benchmark to show you how long does it take to return the result.

0.345295005587713 MS (My Code)

0.55480508330242 MS (Your Code)

And now lets go on what is meant by "cleanest". If i compare the code you will see that its just one line and this is what the StringRegExp was designed for, you have been on this forum long enough therefore why ask a silly question.

[Jos]

I don't understand what is your problem with me. But let me define you what i meant my the "Best", is that my code is fast when it comes to parsing data.

Let me take a stab at that: You are showing an attitude with the statements made that work as a red clot.

Anyway, this is the last off topic post in this thread and think the OP has ample info to go on.

[JLogan3o13]

I don't thiink the question was silly, personally. At the risk of hijacking the OP's thread with this back and forth, I think it can be agreed by all that there are many ways to do things with AutoIT. A difference of .2ms doesn't make me <facepalm> as opposed to BrewMan's code. I wouldn't go throwing "my code is best" around too much in this forum

[gr1fter]

Thanks for all the replies! I do believe I have enough info to get me on my way, I work more on this tomorrow. Thanks again!