xf_StringCaseSensitiveString Functions

Functions to augment the builtin VBA string functions.
Also provide exact equivalents of all the builtin .NET library string class methods The xf.Str. namespace contains case-insensitive versions of these functions. The xf.StrCS. namespace contains identical but case-sensitive versions of these functions.

Module Sections:

• .NET equivalent functions
• Additional string manipulation
• Compare variant values
• Debugging support
• Find string in lists and arrays
• Identification of character classes
• Identification of string classes
• Manipulation of alphanumeric identifiers
• Split on more than one delimiter
• Transform strings

Alphabetical List of Methods:

• CharIsAlpha(Identification of character classes)
• CharIsAlphaNumeric(Identification of character classes)
• CharIsLower(Identification of character classes)
• CharIsNumericInt(Identification of character classes)
• CharIsNumericReal(Identification of character classes)
• CharIsUpper(Identification of character classes)
• CharIsWhitespace(Identification of character classes)
• ClipEnd(Additional string manipulation)
• ClipStart(Additional string manipulation)
• CompareValue(Compare variant values)
• Contains(.NET equivalent functions)
• EndsWith(.NET equivalent functions)
• FindStringInArray(Find string in lists and arrays)
• FixedWidthStr(Additional string manipulation)
• IndexOf(.NET equivalent functions)
• Insert(.NET equivalent functions)
• InStrIdentifier(Manipulation of alphanumeric identifiers)
• IsIdentifierChar(Identification of character classes)
• IsIdentifierFirstChar(Identification of character classes)
• LastIndexOf(.NET equivalent functions)
• PadLeft(.NET equivalent functions)
• PadRight(.NET equivalent functions)
• ProperCaseToSpaced(Transform strings)
• Remove(.NET equivalent functions)
• RemoveAllButAlpha(Transform strings)
• RemoveAllButAlphaNumeric(Transform strings)
• RemoveFromEnd(Additional string manipulation)
• RemoveFromStart(Additional string manipulation)
• RemoveFromStartAndEnd(Additional string manipulation)
• RepeatStr(Additional string manipulation)
• Replace(.NET equivalent functions)
• ReplaceIdentifier(Manipulation of alphanumeric identifiers)
• SafeMid(Additional string manipulation)
• SplitArray(Split on more than one delimiter)
• SplitMultiDelim(Split on more than one delimiter)
• StartsAndEndsWith(Additional string manipulation)
• StartsWith(.NET equivalent functions)
• StringDebugHelper(Debugging support)
• StringInParamList(Find string in lists and arrays)
• StringIsAlpha(Identification of string classes)
• StringIsAlphaNumeric(Identification of string classes)
• StringIsArrayMember(Find string in lists and arrays)
• StringIsCurrency(Identification of string classes)
• StringIsDecimal(Identification of string classes)
• StringIsDouble(Identification of string classes)
• StringIsInteger(Identification of string classes)
• StringIsLong(Identification of string classes)
• StringIsSingle(Identification of string classes)
• StringIsValidGUID(Identification of string classes)
• SubString(.NET equivalent functions)
• ToLower(.NET equivalent functions)
• ToUpper(.NET equivalent functions)
• Trim(.NET equivalent functions)
• TrimEnd(.NET equivalent functions)
• TrimStart(.NET equivalent functions)
• ValueEqual(Compare variant values)
• ValueLike(Compare variant values)
• VariantToPrintableText(Debugging support)