Public Function StringToStringSegments( _ ByVal vValue As Variant _ , ByVal vSeparator As Variant _ , Optional ByVal vCompare As Variant _ ) As Variant
StringToStringSegments("CA|Calif|NV|Nevada") = "CA Calif NV Nevada" StringToStringSegments("Ariz|Calif|Nev|Wash") = "Ariz CalifNev Wash "See also:
StringSegmentXOfLengthY Function StringSegmentsToVariantVector FunctionvValue: The string containing the delimited portions that are to be placed into equal-length segments. Function returns Null if vValue is Null or cannot be fixed up to a String. Function returns an empty string if vValue is an empty string.
vSeparator: The string which separates each of the portions of vValue. vSeparator defaults to an empty string if it is Null or cannot be fixed up to a String. Function returns vValue unchanged if the separator is an empty string (it creates a string with one segment).
vCompare: Specifies the type of comparison used to determine if strings match. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.