Declarations Section, Gettysburg Property, Mayflower Property, Panama Property, Preamble Property, BookmarkToLong Function, BookmarkFromLong Function, BookmarkToString Function, BookmarkFromString Function, CharactersToSQLInExpression Function, EgrepOrStringsToRegexPattern Function, ExcelColumnNumberToLetters Function, FrequencyToBandAbbreviation Function, GetOpt Function, GetVBToken Function, GetVBTokenSample Sub, KeepVBComments Function, PrefixHTMLMetaCharacters Function, PrefixSendKeysMetaCharacters Function, RandomCapitalize Function, StringSimilarity Function, StringsToSQLBetweenExpression Function, StripVBComments Function, StripVBCommentsSample Sub, VBNameToDeriveName Function, WriteCodeBlock Function

Declarations Section

Gettysburg Property

Property whose constant string value contains the text of Lincoln's Address at Gettysburg. This property is used to test the text processing functions.

Mayflower Property

Property whose constant string value contains the text of the Mayflower Compact. This property is used to test the text processing functions.

Panama Property

Property whose constant string value contains the well-known palindrome "A man, a plan, a canal, Panama." This property is used to test the text processing functions.

Preamble Property

Property whose constant string value contains the text of the Preamble to the Constitution of the United States of America. This property is used to test the text processing functions.

Bookmark To Long Function

"Bookmark To Long Integer" or "Long Integer From Bookmark" Converts the DAO "Bookmark" Property to a long integer. "Bookmark" is a Recordset Property within the Data Access Objects (DAO) that acts as the placeholder for a specific record. This is the inverse of the BookmarkFromLong function.

Bookmark From Long Function

"Bookmark From Long Integer" or "Long Integer To Bookmark" Converts a long integer into the corresponding DAO "Bookmark" Property value. "Bookmark" is a Recordset Property within the Data Access Objects (DAO) that acts as the placeholder for a specific record. This is the inverse of the BookmarkToLong function.

Bookmark To String Function

"Bookmark To String" or "String From Bookmark" Converts the DAO "Bookmark" Property to a printable 8-character-long string value. "Bookmark" is a Recordset Property within the Data Access Objects (DAO) that acts as the placeholder for a specific record. This is the inverse of the BookmarkFromString function.

Bookmark From String Function

Converts an 8-character-long printable string into the corresponding DAO "Bookmark" Property value. "Bookmark" is a Recordset property within the Data Access Objects (DAO) that acts as the placeholder for a specific record. This is the inverse of the BookmarkToString function.

Characters To SQL In Expression Function

Convert a string like ABC into a SQL WHERE IN expression. Each unique character becomes a string within the IN expression.

Egrep Or Strings To Regex Pattern Function

"UNIX egrep Or Strings To Regular Expression Pattern" Create a Find pattern that will search for any of several words using a single Find command within Microsoft products like Visual Basic, Access, etc. Convert a UNIX "egrep" (extended global regular expression) like "or" string expression into a pattern recognized by the Microsoft's Find command.

Excel Column Number To Letters Function

Converts numbers into Excel column names. Converts 1 to "A", 26 to "Z", 27 to "AA", etc.

Frequency To Band Abbreviation Function

Returns an abbreviation for the name of the frequency band that describes a particular frequency. The band abbreviations are "VLF", "LF", "MF", "VHF", "UHF", "SHF", and "EHF".

Get Opt Function

"Get Option" Parse the next argument from a string that represents a series of command line arguments. Similar to the UNIX "getopt" function for parsing command line options.

Get VB Token Function

"Get Visual Basic Token" Simple but powerful and almost complete lexical analyzer for Visual Basic code. Removes and returns the next Visual Basic token from a string containing Visual Basic code.

Get VB Token Sample Sub

Print some samples of the GetVBToken function.

Keep VB Comments Function

"Keep Visual Basic Comments" Retain the comments within a string representing a line of Visual Basic code. Returns a string containing the comment portion from a line of Visual Basic source code.

Prefix HTML Meta Characters Function

Fixes-up a string literal so that none of the characters within it will have unintended special meanings when used within HTML documents.

Prefix Send Keys Meta Characters Function

Fixes-up a string literal so that none of the characters within it will have unintended special meanings when used with the Visual Basic SendKeys statement.

Random Capitalize Function

Randomly capitalizes the characters within a string.

String Similarity Function

Returns a percentage characterizing the similarity of the two phrases based upon the number characters which they have in common.

Strings To SQL Between Expression Function

Convert two values into a SQL WHERE expression that will locate a range of values. The exact form of the expression depends upon which of vFrom and vThru are provided.

Strip VB Comments Function

"Strip Visual Basic Comments" Strip the comments from a string representing a line of Visual Basic code. Returns a string containing everything but the comment portion of a line of Visual Basic source code.

Strip VB Comments Sample Sub

Print some samples of the StripVBComments function.

VB Name To Derive Name Function

"Visual Basic Name To Derive Name" Converts a Visual Basic identifier into one that is valid within the Derive. Derive is a symbolic Math program from Soft Warehouse of Honolulu, Hawaii.

Write Code Block Function

Creates a block of text by substituting each of a series of alphanumeric keywords into a "template."

This Windows-based ActiveX DLL provides many useful routines through its function-bearing and data structure classes. Consult the Help file for more information, or call us at 1-310-472-3736. For the latest news and files, visit our home page on the World Wide Web: http://www.entisoft.com