2,462
社区成员
发帖
与我相关
我的任务
分享
'此代码由“正则测试工具 v1.1.43”自动生成,请直接调用TestReg过程
Private Sub TestReg()
Dim strData As String
Dim reg As Object
strData = "1 " & vbCrLf & _
" " & vbCrLf & _
" 22 " & vbCrLf & vbCrLf & vbCrLf & vbCrLf & _
"423" & vbCrLf & vbCrLf & _
"52"
Set reg = CreateObject("vbscript.regExp")
reg.Global = True
reg.IgnoreCase = False
reg.MultiLine = True
reg.Pattern = "^\s*?\r\n"
Debug.Print reg.Replace(strData, "")
End Sub
'去除中间的空行
len1=Len(strTest)
Do
strTest = Replace(strTest, vbCrLf & vbCrLf, vbCrLf)
len2=Len(strTest)
if len1=len2 then exit do
len1=len2
Loop
Dim strTest As String
strTest = strTest & vbCrLf
strTest = strTest & "这是一个测试字符串,最前面有一个空行" & vbCrLf
strTest = strTest & vbCrLf
strTest = strTest & "在这行前面有一个空行" & vbCrLf
strTest = strTest & "在这行后面有若干个空行" & vbCrLf
strTest = strTest & vbCrLf
strTest = strTest & vbCrLf
strTest = strTest & vbCrLf
strTest = strTest & vbCrLf
strTest = strTest & "结束,再加个回车换行" & vbCrLf
Debug.Print "------- 原字符串"
Debug.Print strTest
Debug.Print "-------"
'去除中间的空行
Do
strTest = Replace(strTest, vbCrLf & vbCrLf, vbCrLf)
Loop While InStr(1, strTest, vbCrLf & vbCrLf) > 0
'去除头部空行
If Left(strTest, 2) = vbCrLf Then strTest = Right(strTest, Len(strTest) - 2)
'去除尾部回车换行
If Right(strTest, 2) = vbCrLf Then strTest = Left(strTest, Len(strTest) - 2)
Debug.Print "------- 处理结果"
Debug.Print strTest
Debug.Print "-------"