Public Function DeleteString( _
ByVal vString As Variant _
, Optional ByVal vStartPos As Variant _
, Optional ByVal vLength As Variant _
) As Variant DeleteString("ABCDEFGHIJ", 3, 4) = "ABGHIJ"which is "ABCDEFGHIJ" with four (4) characters removed ("CDEF") starting at the third (3) character. InsertString Function
StrDel SubroutinevString: The string from which a portion (a sub-string) is to be removed. Function returns Null if vString is Null or cannot be fixed up to a String. vStartPos: The position of within vString of the first character to be removed. vStartPos defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number.
vStartPos is set to the beginning of the string if it is less than 1 (one).
vString is returned unchanged if vStartPos is beyond the end of vString.
vLength: The number of characters to be removed from vString. vLength defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number.
vString is returned unchanged if vLength is <= 0 (less than or equal to zero).
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.