以下是引用lanchong在2005-4-12 15:10:00的發(fā)言:
誰(shuí)幫寫(xiě)個(gè)清除空格的函數(shù),不管空格在字段何處,通通清除
新鮮出爐。你試試!嘿嘿。。。
Public Function txtpu(text As Variant)
If Not IsNull(text) Then '字符串為空時(shí)不計(jì)算
Dim my1 As Integer '取字符起始位置
Dim my2 As Integer '取字符終止位置
Dim mytt As Variant ' 取字符
' Dim text As Variant '原始字符串
Dim txt As Variant ' 結(jié)果
' text = text
my1 = 1 '起始位數(shù)
While my1 < Len(text) '循環(huán)次數(shù)
my2 = InStr(my1, text, " ", 1) '取得截取字符的結(jié)束位置
If my2 > 0 Then '是否為最后一次到值
mytt = Mid(text, my1, my2 - my1)
my1 = my2 + 1 '計(jì)數(shù)器加1
Else
mytt = Mid(text, my1)
my1 = Len(text) + 100 '計(jì)數(shù)加100。退出循環(huán)
End If
txt = txt & Trim(mytt)
Wend
txtpu = txt
End If
End Function
[此貼子已經(jīng)被作者于2006-9-24 10:59:30編輯過(guò)]
|