Parse text from clipboard

[BigEdJr]

Hi All,

I am pretty new to this whole scripting thing, but I am enjoying it. I appreciate all the knowledge you all share too.

I am trying paste the last line of text from info I am grabbing from a webpage. When I manually do it it looks like this:

***********************************

Activity - Sessions

Sessions

Add Delete Edit

User Session ID Logged On Minutes since last heartbeat Dual Monitor

1 mseid xx5A 6/16/2008 2:21:52 PM 3 No

2 m3449 xx01 6/16/2008 1:30:24 PM 4 No

3 kdinu xx4D 6/16/2008 1:23:25 PM 1 No

4 lstan xx49 6/16/2008 2:21:40 PM 3 No

5 rhoop xx18 6/16/2008 1:44:31 PM 0 No

6 lstan xxCD 6/16/2008 2:12:49 PM 2 No

7 tclar xx98 6/16/2008 2:02:35 PM 2 No

8 dlawl xx24 6/16/2008 2:22:21 PM 2 Yes

9 m2561 xx44 6/16/2008 1:46:56 PM 3 No

10 ggarc xx46 6/16/2008 1:41:20 PM 3 No

11 lnels xxEB 6/16/2008 1:58:54 PM 1 No

12 m1813 xxDB 6/16/2008 1:14:19 PM 0 No

13 m3910 xx12 6/16/2008 1:44:10 PM 0 No

14 m2448 xx56 6/16/2008 1:37:15 PM 2 No

Query returned: 14

************************************************

All I care about is the "Query returned: x". Is there a way to just paste or send that one to a text file? I am able to get everything (currently using send ("^v")) but I'd like to learn how to parse that info out.

Thanks!

[MrCreatoR]

Hi and wellcome

All I care about is the "Query returned: x". Is there a way to just paste or send that one to a text file? I am able to get everything (currently using send ("^v")) but I'd like to learn how to parse that info out.

You can use StringRegExp...

;Get the clipboard data
$ClipBoard_Content = ClipGet()

;Parse it via RegExp
$Query_Returned = StringRegExpReplace($ClipBoard_Content, "(?i)(?s).*?Query returned: (\d+).*?$", "\1")

;Show the results
MsgBox(64, "Results", "Query Returned: " & $Query_Returned)

[BigEdJr]

Hi and wellcome

You can use StringRegExp...

;Get the clipboard data
$ClipBoard_Content = ClipGet()

;Parse it via RegExp
$Query_Returned = StringRegExpReplace($ClipBoard_Content, "(?i)(?s).*?Query returned: (\d+).*?$", "\1")

;Show the results
MsgBox(64, "Results", "Query Returned: " & $Query_Returned)

Well, that works perfectly. Thank you very much!

Would you mind explaining what all this does/means?

"(?i)(?s).*?Query returned: (\d+).*?$", "\1"

I can use what you gave me fine I just want to understand how and why it works.

Thanks again!

[MrCreatoR]

Would you mind explaining what all this does/means?

I can use what you gave me fine I just want to understand how and why it works.

This is Regular Expressions, look for StringRegExp() function in the help file for the details.