Declarations Section, DeleteVariantVectorElement Function, DeleteVariantVectorElementByContent Function, FirstAtomicArrayElement Function, FirstAtomicNonObjectArrayElement Function, FormatVariantMatrix Function, GroupVariantVector Function, InsertVariantVectorElement Function, LookupValue Function, LookupAdd Function, LookupMultiple Function, LookupSorted Function, LookupSortedMultiple Function, LookupStringToVariantMatrix Function, LookupStringToVariantMatrixSample Sub, MaxLengthVariantVectorElement Function, MinLengthVariantVectorElement Function, RotateVariantVectorDown Function, RotateVariantVectorUp Function, UniqueVariantVector Function, ReDimVerify Sub

Declarations Section

Delete Variant Vector Element Function

There is no way to delete the last element with contraction, because an array must have at least one element when dimensioned.

Delete Variant Vector Element By Content Function

First Atomic Array Element Function

Return the value of the first non-array element of a variant using a depth-first search. If the argument is not a variant array, return it. See also the FirstAtomicNonObjectArrayElement function. Note: Handles arguments containing objects and nested variant arrays. v1.3 Pro Change: The implementation of this function has changed.

First Atomic Non Object Array Element Function

Return the value of the first non-array, non-object element of a variant using a depth-first search. If the argument is not a variant array, return it. Returns Empty instead of an Object reference if the first non-array element is a vbObject type value. See also the FirstAtomicArrayElement function. Note: Handles arguments containing objects and nested variant arrays. v1.3 Pro Change: The implementation of this function has changed.

Format Variant Matrix Function

Format the values from a two-dimensional array of variant values into a tabular format, returning the result as a String. The Justify Codes are those recognized by the JustifyText function. They are applied to each cell (individual value) within the array.

Group Variant Vector Function

Takes elements 1..UBound from vFm, and does a Group By Count * operation, putting the values in rTo(1, n) and the corresponding counts in rTo(2, n). This subroutine also performs a Sort Unique function.

Insert Variant Vector Element Function

Lookup Value Function

Note: This function does not fix-up its arguments.

Lookup Add Function

Lookup Multiple Function

Note: This function looks up EACH character of vValue within the lookup table.

Lookup Sorted Function

Lookup Sorted Multiple Function

Note: This function looks up EACH character of vValue within the lookup table.

Lookup String To Variant Matrix Function

Lookup String To Variant Matrix Sample Sub

Max Length Variant Vector Element Function

"Maximum Length Variant Vector Elements"

Min Length Variant Vector Element Function

"Minimum Length Variant Vector Elements"

Rotate Variant Vector Down Function

Rotates all of the elements down within a variant array, i.e.: A(1) becomes A(2), A(2) becomes A(3), A(3) becomes A(1).

Rotate Variant Vector Up Function

Rotates all of the elements up within a variant array, i.e.: A(3) becomes A(2), A(2) becomes A(1), A(1) becomes A(3).

Unique Variant Vector Function

"Unique Variant Vector Elements" Removes duplicate sequential elements of a one-dimensional variant array. Examines elements from 1..UBound. Use temporary space in case To and Fm arrays are the same. Temporary space is needed because there is no way to determine if rTo() and vFm() as really the same arrays.

Re Dim Verify Sub

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