Class Module
26 Members
★ 1 Top 20
String Extras Class
Entisoft Tools 2.0 Object Library · StringExtras · 19 Functions · 4 Properties · 2 Subroutines
Declarations
Declarations
The functions within this group perform miscellaneous string and text processing operations. Copyright 1998 Entisoft
Section
Gettysburg
Gettysburg
Property whose constant string value contains the text of Lincoln's Address at Gettysburg. This property is used to test the text processing functions.
Property
Mayflower
Mayflower
Property whose constant string value contains the text of the Mayflower Compact. This property is used to test the text processing functions.
Property
Panama
Panama
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.
Property
Preamble
Preamble
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.
Property
BookmarkFromLong
Bookmark From Long
"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.
Function
BookmarkFromString
Bookmark From String
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.
Function
BookmarkToLong
Bookmark To Long
"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.
Function
BookmarkToString
Bookmark To String
"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.
Function
CharactersToSQLInExpression
Characters To SQL In Expression
Convert a string like ABC into a SQL WHERE IN expression. Each unique character becomes a string within the IN expression.
Function
EgrepOrStringsToRegexPattern
Egrep Or Strings To Regex Pattern
"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.
Function
ExcelColumnNumberToLetters
Excel Column Number To Letters
Converts numbers into Excel column names. Converts 1 to "A", 26 to "Z", 27 to "AA", etc.
Function
FrequencyToBandAbbreviation
Frequency To Band Abbreviation
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".
Function
GetOpt
Get Opt
"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.
Function
GetVBToken
Get VB Token
"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.
Function
KeepVBComments
Keep VB Comments
"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.
Function
PrefixHTMLMetaCharacters
Prefix HTML Meta Characters
Fixes-up a string literal so that none of the characters within it will have unintended special meanings when used within HTML documents.
Function
PrefixSendKeysMetaCharacters
Prefix Send Keys Meta Characters
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.
Function
RandomCapitalize
Random Capitalize
Randomly capitalizes the characters within a string.
Function
StringSimilarity
String Similarity
Returns a percentage characterizing the similarity of the two phrases based upon the number characters which they have in common.
Function
StringsToSQLBetweenExpression
Strings To SQL Between Expression
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.
Function
StripVBComments
Strip VB Comments
"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.
★ Top 20
Function
VBNameToDeriveName
VB Name To Derive Name
"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.
Function
WriteCodeBlock
Write Code Block
Creates a block of text by substituting each of a series of alphanumeric keywords into a "template."
Function
GetVBTokenSample
Get VB Token Sample
View VB6 signature, parameters, and usage notes.
Sub
StripVBCommentsSample
Strip VB Comments Sample
View VB6 signature, parameters, and usage notes.
Sub