文本文件的结构有问题。不要用不确定的空格来区分记录,最好用换行。那样可以执行得更快,代码也更简单。下面的代码临时写的,没有测试。你自己调试吧。 Dim strTmp As String, bytArr() As Byte, strArr() As String, i As LongOpen "test.txt" For Binary As #1 Redim bytArr(LOF(1) - 1) Get #1, , bytArr Close #1strTmp = StrConv(bytArr) strArr = Split(strTmp, " ")Open "new.txt" For Output As #2 For i = 0 To Ubound(strArr) If Right(strArr(i), 3) = "aa9" Then Print #2, strArr(i) Next i Close #2
[\d]{5,5}?aa9
Dim strTmp As String, bytArr() As Byte, strArr() As String, i As LongOpen "test.txt" For Binary As #1
Redim bytArr(LOF(1) - 1)
Get #1, , bytArr
Close #1strTmp = StrConv(bytArr)
strArr = Split(strTmp, " ")Open "new.txt" For Output As #2
For i = 0 To Ubound(strArr)
If Right(strArr(i), 3) = "aa9" Then Print #2, strArr(i)
Next i
Close #2