_VLookUpAut

[SmOke_N]

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 August 21, 2008 by SmOke_N

[ptrex]

@SmOke_N

Very nice, can come in handy some time !!

regards,

ptrex

[rajeshontheweb]

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.