AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

What's the best way to use AHK as a SQL-Like tool?

 
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Ask for Help
View previous topic :: View next topic  
Author Message
Guest






PostPosted: Wed Nov 29, 2006 9:45 pm    Post subject: What's the best way to use AHK as a SQL-Like tool? Reply with quote

Let's say I have internal variables that I wish to use to filter a text file, so that AHK displays only certain rows in the text file.

For example, say I am looking for a particular last name in a field of many fields, in a text file with over 6000 records. Only those fields that match a specific field of a row should get displayed. The last name could be in other parts of the field but I only want to look in specific columns for the match.

My text file is delimited of course.

What is the best AHK method to go about doing this?

Thanks in Advance
Back to top
Titan



Joined: 11 Aug 2004
Posts: 5068
Location: imaginationland

PostPosted: Wed Nov 29, 2006 9:58 pm    Post subject: Reply with quote

RegExMatch()
_________________

RegExReplace("irc.freenode.net/ahk", "^(?=(.(?=[\0-r\[]*((?<=\.).))))(?:[c-\x73]{2,8}(\S))+((2)|\b[^\2-]){2}\D++$", "$u3$1$3$4$2")
Back to top
View user's profile Send private message Visit poster's website
n-l-i-d
Guest





PostPosted: Wed Nov 29, 2006 10:02 pm    Post subject: Reply with quote

Loop, Parse (example #4, combination of Loop, Read and Loop, Parse)
Back to top
skwire



Joined: 18 Jan 2006
Posts: 132
Location: Conway, Arkansas

PostPosted: Wed Nov 29, 2006 10:46 pm    Post subject: Reply with quote

I've written many tools for work in AHK that do exactly what you're wanting to do. Are you able to share a few data row samples?
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
ScottEdge



Joined: 14 Aug 2005
Posts: 57
Location: Connecticut,USA

PostPosted: Thu Nov 30, 2006 5:36 am    Post subject: Reply with quote

you could just use SQL with an include

http://www.autohotkey.com/forum/viewtopic.php?t=12752&highlight=sql
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Ask for Help All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group