| View previous topic :: View next topic |
| Author |
Message |
Guest
|
Posted: Wed Nov 29, 2006 9:45 pm Post subject: What's the best way to use AHK as a SQL-Like tool? |
|
|
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
|
Posted: Wed Nov 29, 2006 9:58 pm Post subject: |
|
|
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 |
|
 |
n-l-i-d Guest
|
Posted: Wed Nov 29, 2006 10:02 pm Post subject: |
|
|
| Loop, Parse (example #4, combination of Loop, Read and Loop, Parse) |
|
| Back to top |
|
 |
skwire
Joined: 18 Jan 2006 Posts: 132 Location: Conway, Arkansas
|
Posted: Wed Nov 29, 2006 10:46 pm Post subject: |
|
|
| 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 |
|
 |
ScottEdge
Joined: 14 Aug 2005 Posts: 57 Location: Connecticut,USA
|
|
| Back to top |
|
 |
|