View topic - simple problem with RegExMatch() or InStr() • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

simple problem with RegExMatch() or InStr()

Page 1 of 1

[ 12 posts ]

Print view | E-mail friend

Previous topic | Next topic

Author

Message

peteryy

Post subject: simple problem with RegExMatch() or InStr()

Posted: July 4th, 2009, 5:24 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

im new to autohotkey, :cry:

i need to copy every pic id and its price to save in other place and it was around 500KB file, so it will take me about half day time to search, copy and paste if i do it in manualy. i was trying to get the id number or by its price from a file, but i fail to creating the pattern to search. any one pls help??
this is the content of file that i want to search

Quote:

this my testing code

Code:

filedelete, test.txt



    Loop,5
   {
   Loop, read, pc.txt, var
   {

      FileRead,var1,pc.txt
      StringReplace, var1, var1, </TD>,`n , All


      start1:=InStr(var1,"java",0,start1)+14
      end1:=InStr(var1,",'EAT",0,start1)
      StringMid,var1,var1,% start1,% end1-start1
      FileAppend, %var1%`n, Test.txt
      ;count += 1
      ;msgbox <%start1%>  <%end1%>
   }
   
   }

and lastly this is the result that i manage to produce

Quote:

665043
equiv=refresh content=4>
<PRE id="TRANS_DATA">
<TR><TD colspan=7 class='x2'>Race 1<TR><TD colspan=7 class='x3'>unconfirmed orders<TR><a href="javascript:mr(663362
663362
664258
664413
664616
663995
663136
663779
664412
665290
665051
664615
663980
664841
663580
662945
663123
663554
664171
663775
664397
665235
665074
664620
663988
664835
663397
662942
663181
663457
664229
663771
664420
665141

now my problem is my coding will resulting endless loop and accidently resulting non id data for me...
any one pls help me to solve this??
pls pls...dun wana waste so many time for just search, copy and paste...
:cry:

pls

Top

animeaime

Post subject:

Posted: July 4th, 2009, 5:45 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

Dumb question, but can you give a "snip" (i.e. example) of a pic ID? By using this example, you can extract the pattern.

For example, I think this is a pic ID, but I want to be sure.

Code:

"javascript:mr(664258,'PIC','AU','SG')"

In the above example, you want the 664258, right?

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

animeaime

Post subject:

Posted: July 4th, 2009, 6:00 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

OK, below is my initial attempt, please give feedback on what it does right and wrong, so I can adjust the code. Of course, you can adjust the code as you see fit. As testing, I copied the contents of the "quote block", the massive listing of code, to "pc.txt". I then ran the below code and it created a list of 27 pic IDs in "test.txt".

Code:

ReadFile := "pc.txt"
WriteFile := "test.txt"

;reads the text to match from <ReadFile>
FileRead, text, %ReadFile%
FileDelete, %WriteFile%
start := 1

;finds all occurrences of "javascript:mr(number,'PIC'"
;   and appends the number, followed by a newline (\n) to the specified <WriteFile>
while pos := RegExMatch(text, "javascript:mr\((?<PicID>\d++),'PIC'", match, start)
{
    FileAppend %MatchPicID%`n, %WriteFile%
    start := pos + strLen(match)
}

MsgBox, Done

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

peteryy

Post subject:

Posted: July 4th, 2009, 6:40 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

thx to animeaime
haha...
its work!~!~and thx for fast respond...
so wonderful
for my stupid question again...
(text, "javascript:mr\((?<PicID>\d++),'PIC'", match, start)
can u explain for me??
and izit PicID = %MatchPicID%
becouse im quite blur with RegExMatch's perl expersion
thx again

Top

peteryy

Post subject:

Posted: July 4th, 2009, 6:45 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

how about if i want to search all pic ID number which match its price 4.90 only??

Top

animeaime

Post subject:

Posted: July 4th, 2009, 7:13 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

So, it does the job? Good.

Ok. here's the breakdown.

When working with regular expressions, you are looking for a pattern. By using this pattern, you find what you seek. So, from your examples, it seems you were looking for "javascript:mr(" followed by a number, followed by ",'PIC'". For example, "javascript:mr(664258,'PIC'" would be one such match.

Once you figure out the pattern, you want to figure out what you want to capture, if anything. You wanted the pic ID, the number, so we want to capture it. Also, you need to figure out what remains the same, and what changes. In this case, only the number changes, the rest of it remains the same. So, in the resulting RegEx, everything but the number is literal text.

Code:

;the RegEx I used (in red, the literal text)
"javascript:mr\((?<PicID>\d++),'PIC'"

When working with regular expressions, don't forget that some characters need to be escaped, because they have special meaning to the RegEx engine. Check out the RegEx - Quick Reference for a full list of these "metacharacters".

For example, an open parenthesis has special meaning, so to match a literal opening parenthesis, we need to precede it with a backslash ("\")).

Code:

;the RegEx I used
"javascript:mr\((?<PicID>\d++),'PIC'"

OK, hopefully you are still following me. If not, feel free to ask questions on anything I mention.

Now, after handling the literal text (the part that doesn't change), we need to handle the part that does - in this case, the number. So, where the number was in the example, "javascript:mr(664258,'PIC'", we need to replace it with a RegEx that matches "a number". Since the number is a decimal number (base 10) and can be "any length" (for all I know), I decided on this RegEx, "(?<PicID>\d++)". This RegEx will match one ore more digits and store it in the named group, "PicID".

The "(?<PicID>" starts a named-capture group. This allows storing a value which can later be retrieved - see the use of "MatchPicID" in the code. "PicID" is the group, and "Match" is the "UnquotedOutputVar" I specified when calling RegExMatch.

The "\d++" matches one or more digits. "\d" means "a digit" (0-9). The "+" after means "one or more". The next "+" makes it possessive - this means that no backtracing will be done. Since the next character is a comma, there is no reason to backtrace. If you don't understand what I mean by backtracing, I refer you to an AWESOME RegEx tutorial which is what I studied when I first learned RegExes. The link for possessive is to the page in the tutorial for possessive quantifiers.

So, merging "what stays the same" with "what changes", I ended up with the RegEx I used. As stated before, if you have any questions, feel free to ask. I would also recommend checking out the tutorial I mentioned. I would say it's a must-have for anyone serious about learning regular expressions.

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

animeaime

Post subject:

Posted: July 4th, 2009, 7:14 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

peteryy wrote:

how about if i want to search all pic ID number which match its price 4.90 only??

Where is the price found in the input? Can you give an example? In other words, how can you tell the price for a pic?

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

peteryy

Post subject:

Posted: July 4th, 2009, 7:32 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

haha...still in progress to digest...
cant imagine that respond so fast...

Quote:

<TR><TD colspan=7 class='x2'>Race 1<TR><TD colspan=7 class='x3'>unconfirmed orders<TR><a href="javascript:mr(663362,'PIC','AU','SG')"><TD>1<TD class='x5'>4<TD>12<TD>0<TD>4.65<TD>44/0<TD>Del</TD></a><TR><a href="javascript:mr(664258,'PIC','AU','SG')"><TD>1<TD class='x5'>4<TD>10<TD>10<TD>4.75<TD>51/15<TD>Del</TD></a><TR><a href="javascript:mr(664413,'PIC','AU','SG')"><TD>1<TD class='x5'>4<TD>22<TD>22<TD>4.80<TD>42/12<TD>Del</TD></a><TR><a href="javascript:mr(664616,'PIC','AU','SG')"><TD>1<TD class='x5'>4<TD>17<TD>17<TD>4.90<TD>51/15<TD>Del</TD></a><TR><a href="javascript:mr(663995,'PIC','AU','SG')"><TD>1<TD class='x5'>4<TD>0<TD>15<TD>4.90<TD>0/10<TD>Del</TD></a><TR><a href="javascript:mr(663136,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>30<TD>0<TD>4.50<TD>25/0<TD>Del</TD></a><TR><a href="javascript:mr(663779,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>0<TD>13<TD>4.75<TD CLASS=RD>0/6<TD>Del</TD></a><TR><a href="javascript:mr(664412,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>22<TD>22<TD>4.80<TD>44/12<TD>Del</TD></a><TR><a href="javascript:mr(665290,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>12<TD>12<TD>4.80<TD CLASS=RD>8/7<TD>Del</TD></a><TR><a href="javascript:mr(665051,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>17<TD>17<TD>4.85<TD CLASS=RD>11/6<TD>Del</TD></a><TR><a href="javascript:mr(664615,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>22<TD>22<TD>4.90<TD>58/15<TD>Del</TD></a><TR><a href="javascript:mr(663980,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>0<TD>15<TD>4.90<TD>0/10<TD>Del</TD></a><TR><a href="javascript:mr(664841,'PIC','AU','SG')"><TD>1<TD class='x5'>5<TD>26<TD>26<TD>5.00<TD>55/15<TD>Del</TD></a><TR><a href="javascript:mr(663580,'PIC','AU','SG')"><TD>1<TD class='x5'>6<TD>13<TD>13<TD>4.10<TD>56/15<TD>Del</TD></a><TR><a href="javascript:mr(662945,'PIC','AU','SG')"><TD>1<TD class='x5'>6<TD>10<TD>10<TD>4.10<TD>54/15<TD>Del</TD></a><TR><a href="javascript:mr(663123,'PIC','AU','SG')"><TD>1<TD class='x5'>6<TD>30<TD>0<TD>4.50<TD>27/0<TD>Del</TD></a><TR><a href="javascript:mr(663554,'PIC','AU','SG')"><TD>1<TD class='x5'>6<TD>12<TD>0<TD>4.65<TD>44/0<TD>Del</TD></a><TR><a href="javascript:mr(664171,'PIC','AU','SG')"><TD>1<TD class='x5'>6<TD>4<TD>4<TD>4.75<TD>52/15<TD>Del</TD></a>

Top

animeaime

Post subject:

Posted: July 4th, 2009, 7:43 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

OK, I'm not sure if this simplification leads to false positives, but here's the new version. This version assumes that a price, "#.## "will follow every pic ID, and that the first number in the form "#.##" after the pic ID is its price. If these assumptions are not valid, I can modify it as such. Note the parts in red are the changes from the previous version.

Code:

ReadFile := "pc.txt"
WriteFile := "test.txt"

;reads the text to match from <ReadFile>
FileRead, text, %ReadFile%
FileDelete, %WriteFile%
start := 1

/*
finds all occurrences of "javascript:mr(number,'PIC'"
   followed by a price (#.##) zero or more characters away
For each pic ID / price, the following is appended
"PicID Price`n" - the PicID, a space, the price, and the newline character, "`n"
*/
while pos := RegExMatch(text, "javascript:mr\((?<PicID>\d++),'PIC'.*?(?<Price>\d\.\d{2})", match, start)
{
    FileAppend %MatchPicID% %MatchPrice%`n, %WriteFile%
    start := pos + strLen(match)
}

MsgBox, Done

The output (text.txt):

Code:

663362 4.65
664258 4.75
664413 4.80
664616 4.90
663995 4.90
663136 4.50
663779 4.75
664412 4.80
665290 4.80
665051 4.85
664615 4.90
663980 4.90
664841 5.00
663580 4.10
662945 4.10
663123 4.50
663554 4.65
664171 4.75
663775 4.75
664397 4.80
665235 4.80
665074 4.85
664620 4.90
663988 4.90
664835 5.00
663397 4.10
662942 4.10

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

peteryy

Post subject:

Posted: July 4th, 2009, 7:46 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

is working is working!~!~

thx for provide me tutorial to follow with..
now i get what u mean in ((?<PicID>\d++)...
haha...
thx you very much..
u save my life alot
i need to put more time to understand Regular-Expressions
i dun neo how to say...
thx

Top

animeaime

Post subject:

Posted: July 4th, 2009, 7:52 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

You're welcome, glad to help. Hope you check out the tutorial - it's an even bigger life saver than me

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

peteryy

Post subject:

Posted: July 4th, 2009, 7:55 am

Joined: March 12th, 2009, 6:18 pm
Posts: 16

okay i will stick to it..i promis thx again :lol:

Top

Page 1 of 1

[ 12 posts ]

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: BrandonHotkey, Exabot [Bot], Google [Bot], krajan, patgenn123 and 60 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum