Public Function StripRightNCharacters( _ ByVal vString As Variant _ , ByVal vNumChars As Variant _ ) As Variant
StripRightNCharacters("123456789", 3) = "123456" StripRightNCharacters("123456789", 10) = "" StripRightNCharacters("123456789", -5) = "123456789" StripRightNCharacters(12345, 3) = "12"See also:
ShiftStringRight FunctionNote: Similar to the ShiftStringRight function, except negative values for vNumChars cause this function to return the entire string, and values of vNumChars greater than the length of vString cause this function to return an empty string.
vString: The string whose right-most characters are to be removed. Function returns Null if vString is Null or cannot be fixed up to a String.
vNumChars: The number of characters to be removed. Function returns Null if vNumChars is Null or cannot be fixed up to a number.
Function returns vString unchanged if vNumChars is <= 0 (less than or equal to zero).
Function returns an empty string if vNumChars is greater than length of the string vString.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.