Can someone give me
a function to strip nulls
from a string?
Thanks!
Printable View
Can someone give me
a function to strip nulls
from a string?
Thanks!
Use the replace function
Code:strText = Replace(strText, vbNull, "")
UsageCode:Function StripNullChar(ByVal sIn As String) As String
StripNullChar = Left(sIn, InStr(1, sIn, vbNullChar) - 1)
End Function
Code:MyString = StripNullChar(MyString)