Manage
Learn to apply best practices and optimize your operations.
Strip String Function
Function StripString
syntax
String$ = StripString( Arg1$, Arg2$)
Arguments
Arg1$ : String that you want to strip
Arg2$ : Array of string, contains the values that you want to remove from
Arg1$
Return value : String
Example
sFaxNumber$ = "(32) 16/44.54.63"
Redim argu(8) As String
argu(0) = "/"
argu(1) = "."
argu(2) = ","
argu(3) = "-"
argu(4) = "+"
argu(5) = "("
argu(6) = ")"
argu(7) = " "
argu(8) = ";"
sFaxNumber$ = StripString( sFaxNumber$, argu)
print sFaxNumber$ ' result : 3216445463
Function StripString( StripValue As String, StripArgument() As String)
tmp$ = StripValue
Length% = Len(tmp$)
For i% = Lbound( StripArgument ) To Ubound( StripArgument )
While (Instr( 1, tmp$, StripArgument(i%)) > 0)
place% = Instr( 1, tmp$, StripArgument(i%))
tmpsuffix$ = Left$(tmp$, (place% - 1) )
tmpprefix$ = Mid$(tmp$, (place%+1), (Length% - place%) )
tmp$ = tmpsuffix$ & tmpprefix$
Wend
Next
StripString = tmp$
End Function
Start the conversation
0 comments