AutoHotkey Community

It is currently May 27th, 2012, 12:19 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: November 30th, 2009, 6:59 pm 
Offline

Joined: February 24th, 2006, 12:56 am
Posts: 172
i need to get some data from database, the problem is that data i search for and query are not indentical. it is books database so the book titles sometimes are not the same. how to match as close as possible with regex?


thanks for helping this noob ;)


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: November 30th, 2009, 7:46 pm 
Offline
User avatar

Joined: March 19th, 2008, 12:43 am
Posts: 5480
Location: the tunnel(?=light)
So are you using regex to match the data in the database? To match the title of the app window? What are you using it for? :?:

_________________
Image
Try Quick Search for Autohotkey or see the tutorial for newbies.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: November 30th, 2009, 11:54 pm 
Offline

Joined: February 24th, 2006, 12:56 am
Posts: 172
to match actual data


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: December 1st, 2009, 12:36 am 
Offline

Joined: December 18th, 2008, 9:03 pm
Posts: 54
It wound be next to impossible to design an expression that matches without sample data. If pulling from a database, the idea should be that the title would be in a single field by itself, so not sure where the matching would come into play here.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: December 1st, 2009, 11:31 am 
Offline

Joined: February 24th, 2006, 12:56 am
Posts: 172
here is simple example

i have this book in the database "The Go Getter"

how can i verify that this book is in the database "Go-Getter"
basically i need to see is book already in the database

how would you do it?


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: December 2nd, 2009, 5:46 pm 
Offline

Joined: December 18th, 2008, 9:03 pm
Posts: 54
if you were doing it using a regular expression, it should be something like:

Go[[:space:][:punct:]]Getter

[:space:] = Any whitespace characters (space, tab, NL, FF, VT, CR)
[:punct:] = Punctuation symbols . , " ' ? ! ; : # $ % & ( ) * + - / < > = @ [ ] \ ^ _ { } | ~

Are there some kind of delimiters around the text? I keep picturing you having output similar to something below.

ISBN33749487423 Author,Mike Go Getter, The SKU554564

If you were wanting to grab the whole title and store it in a variable or something, the text around the title could be important.


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: Leef_me, Maestr0, Pulover, rjgatito, XstatyK, Yahoo [Bot] and 20 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

Search for:
Powered by phpBB® Forum Software © phpBB Group