While writing programs, I have often searched the Web for answers to particular problems, and have been grateful for the assistance gleaned from many sources.
In the interest of returning the favour/s, this small group of pages has been written. I hope that the contents will be of interest and that they will benefit other programmers searching for an answer.
Binary search becomes very useful when large arrays are used. The developed Binary Search algorithm handles mixed numerical-alphanumerical array data - a simple array or an array of arrays. It optionally returns the first instance of a target value, permitting one to iterate up through the other instances of that value.
Reading and writing .csv files into/from arrays is conveniently carried out by two dedicated functions - see Read and Write .csv files
During processing of incoming data, usually from others, you may need to error-trap and validate the data, issuing an Error-Report to the originator. A convenient way to do this is to send an email automatically. Using ActiveX and Outlook, the AutoMail function fulfills this.
To avoid the operating system ActiveX warnings, your program should run under an .hta envelope, ie, as an application (like an .exe file). Details of how to do this are given.
IE issues warnings regarding the length of a running script. When handling complex calculations/disk operations, etc, these warnings become a nuisance and detract from usability, adding operator annoyance. To avoid continuous long-script reminders, one needs to "tune" the registry. This is quite simple.
A desktop shortcut icon to startup your application is useful and gives a nice finishing touch.
I hope these pages prove useful! Please hi-light the portions of text you wish to retain, and use 'Copy' or ctrl+C.