如下是去掉中间的空格和换行空格的可调用程序供参考(当然,不合乎要求,后面有两个方法请试试):
Public Function DeleteSpace1(Tmp As String) As String
'删掉字符串中的换行符和空格的程序
Dim a As String, b As String
Dim i As Long, j As Long, k As Long
a = Tmp
b = ""
k = Len(a)
For i = 1 To k
j = Asc(Mid(a, i))
If j <> 10 And j <> 13 And j <> 32 And j <> Asc(" ") Then '最后一个百条件是全角空格
b = b & Chr(j)
End If
Next
DeleteSpace1 = b
End Function
后面是符合要求的方法,其实语句Trim 可能就可以去掉末尾的空白(前后都能去掉),您试试,还可以用Righttrim(去掉末尾空白),还可以参考去掉后缀0的方法逐个去掉末尾的空白(换行符好像就是产生7个空格):(仅供参考)
去掉后缀0的程序:
Private Function qdhz0(sa As String) As String
a = sa
Do While Right(a, 1) = "0"
a = Left(a, Len(a) - 1)
Loop
If a = "" Then
a = 0
Else
a = a
End If
qdhz0 = a
End Function
去掉后缀空白:
Private Function qdhzkg(sa As String) As String
a = sa
Do While Right(a, 1) = " "
a = Left(a, Len(a) - 1)
Loop
If a = "" Then
a = 0
Else
a = a
End If
qdhzkg = a
End Function
[此贴子已经被作者于2021-3-1 12:24编辑过]