Sign in to follow this  
Followers 0
SmOke_N

_VLookUpAut

3 posts in this topic

#1 ·  Posted (edited)

There was a request for something similar here: http://www.autoitscript.com/forum/index.php?showtopic=78711

I found it made for a quick look up on csv/tsv files which was nice.

Example calls:

#include <array.au3>
Local $s_string =   "Name,Phone,Etc" & @CRLF & _
                    "Brown,999999,aaaa" & @CRLF & _
                    "Jones,888888,zzzzz" & @CRLF & _
                    "Williams,555555,ccccc" & @CRLF & _
                    "Smith,777777,wwww" & @CRLF & _
                    "Kennedy,333333,eeeee"
                   
Local $a_matches = _VLookupAut($s_string, "Jone", "Name", "Etc", True)
_ArrayDisplay($a_matches)
Local $a_matches = _VLookupAut($s_string, "Jone", 1, 2, True)
_ArrayDisplay($a_matches)
Edited by SmOke_N

Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer.

Share this post


Link to post
Share on other sites



great, i am gonna get my dream job done!

i have been breaking my mind to device a very simple addressbook which will base itself on a adata file across network - should be simple superfast, network efficient.

i have something similar in ms access but two downturns were , ms access required to work, version probs, speed (ms acess does take a few seconds to load...) this is gonna make it easier for me to work with autoit because i am good at reading and writing txt files with autoit but was wondering how it would be doing a search by field - i use vlookup in msaccess so this is gonna be a boon to me thanks mate.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0