Public Function StripCharacters( _ ByVal vLine As Variant _ , ByVal vStripChars As Variant _ , Optional ByVal vCompare As Variant _ ) As Variant
StripCharacters("A1B2A1B2", "1234567890") = "ABAB" StripCharacters("123ABC123", "DCBA") = "123123"See also:
StripRangeOfCharacters Function DifferenceCharacters Function KeepCharacters FunctionNote: Similar to the StripRangeOfCharacters function, except that one requires the range of ASCII values that will stripped and it uses Binary comparisons.
vLine: String containing the characters which should be copied to the result string as long as they do not also appear within string vStripChars. Function returns Null if vLine is Null or cannot be fixed up to a String.
vStripChars: String containing the characters which should not be copied to the result string when they appear within string vLine. Function returns Null if vStripChars is Null or cannot be fixed up to a String.
vCompare: specifies the type of string comparison used to determine if characters 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.