Moderators SmOke_N Posted August 21, 2008 Moderators Share Posted August 21, 2008 (edited) There was a request for something similar here: http://www.autoitscript.com/forum/index.php?showtopic=78711I 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 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. Link to comment Share on other sites More sharing options...
ptrex Posted August 21, 2008 Share Posted August 21, 2008 @SmOke_N Very nice, can come in handy some time !! regards, ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
rajeshontheweb Posted April 7, 2009 Share Posted April 7, 2009 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. Started late is much better than having never started it!!!!Failure is another step towards success. I've been messing around with: Adding Entry to 'Hosts'File Information Lister (Logger)Yet Another AutoIT Error Handler Yet Another AutoIT Error Handler & Debugger Control your App's TaskBar Button YCurrency Ticker (Latest Release : 16 Apr 2009)_WinInetInternetCheckConnection UDF Symantec Definitions Lister UDF _GetLocalIPAddresses UDF UDF to get Special Folder Information WMI_NetworkAdapterConfiguration2Array WMI_CDRomDriveCapabilities _ScriptExists - Check if your au3 script is running!! Uninstaller UDF Get Version for your application (at script level or compiled stage) Uninstaller Pro - faster alternative to windows application removal applet Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now