7,785
社区成员




Dim strLine As String
Open "Demo.txt" For Input As #1
Do Until EOF(1)
Line Input #1, strLine
If Trim(Replace(strLine, vbTab, "")) > "" Then
Debug.Print strLine
End If
Loop
Close #1
Sub test()
Dim w1 As String, i As Integer, ww
w1 = Chr(9) & Chr(9) & Chr(9) '带有符号的“空行”
w1 = w1 & vbCrLf & "aaa" & Chr(9) & "bbb" & Chr(9) & "ccc"
w1 = w1 & vbCrLf & "aaa" & Chr(9) & "bbb" & Chr(9) & "ccc"
w1 = w1 & vbCrLf & "aaa" & Chr(9) & "bbb" & Chr(9) & "ccc"
w1 = Replace(w1, vbCrLf & Chr(9) & Chr(9) & Chr(9) & vbCrLf, vbCrLf, 1, , vbTextCompare)
w1 = Replace(w1, vbCrLf & Chr(9) & Chr(9) & Chr(9), "", 1, , vbTextCompare)
w1 = Replace(w1, Chr(9) & Chr(9) & Chr(9) & vbCrLf, "", 1, , vbTextCompare)
w1 = Replace(w1, Chr(9) & Chr(9) & Chr(9), "", 1, , vbTextCompare)
Debug.Print w1
End Sub