Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
Samples from Users
- !!DISCLAIMER!!
- ADO Table Schemas
- Append RTF files Using COM
- AskFileName Alternative
- Binary OLE example
- Brother Label Printer with b-pac SDK
- Check CDROM Ejected
- COM Object for DLL Calls
- Convert Word Doc to PDF
- Create XML DB from the TXT file then do OLE Lookup
- Creating Shaped Hierarchical Recordset
- Crystal Reports Print Extender
- CSMail Search Inside Mime Messages
- Date Picture Taken
- Delete Message from Exchange
- Directory Browse Dialog Created Using OLE Shell Functions
- Display Spreadsheet as HTML
- Email Address Validator
- Enabling Automatic Updates
- Enumerate Certificates
- Enumerate Windows Updates
- Export Data crom Crystal Reports to Excel
- Forwarding Email Messages
- Get Current Unix TimeStamp
- GroupWise and WinBatch
- IBM Personal Communications Connect Via COM
- IIS UDFs
- Import CSV File Using Office Web Components Spreadsheet
- Inspect mail messages - CDO
- Locate and Validate Credit Card Numbers Using RegExp
- MakeCAB
- Minimize all windows
- Oracle Object for OLE OO4O Access
- Powershell COM
- Publisher SaveAsPicture
- Remove Duplicate Lines from Text File
- Remove SMS Cache Folder
- Set Groupwise Contacts Link
- SkyPe Enumerate Contacts
- SkyPe UDFs
- SNMP v1 Examples
- SQL Syntax Tool
- Symantec LiveStateRecovery ImageJob Code
- Symantec ProtectorAuto OLE Script
- Template Create IIS Site
- Use XMLHTTP to Download a File
- Windows Update Agent
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Create XML DB from a TXT File then Do an OLE Lookup
Keywords: XML OLE Lookup
The attached zip file contains
xmlseekm.wbt <---- modified script mex.txt <---- CityCode values for MexicoThe text file has near 7,000 entries. For those of you sans telecom - after you dial 011, if the next 2 digits are 52, then the call is routed to Mexico, ergo 52 is the CountryCode for Mexico. The next 4 digit after the 52 determine the citycode, then on to the person you are calling,
The (where 9=any number) 529999 combination in Mexico resembles the areacode/location or NPA/NXX in the U.S.
suffice to say each line in the text file has a 6-digit citycode followed by the city.
Similar to the last script, xmlseekm first creates an XML database from the text file, then permits you to search or add to the database.
In testing I entered 528760 (city of Monterry), which is about at the end of the text file and results were returned in under a second.
MEX.ZIP
Article ID: W14938
File Created: 2017:08:29:11:58:50
Last Updated: 2017:08:29:11:58:50