7,763
社区成员
发帖
与我相关
我的任务
分享
'测文件
'13751884586
'13922541252
'13844332952
'13511125482
'13152541212
'13545121234
'13525443325
Private Sub Command1_Click()
'4433 111 1212
Call Find(4433, 111, 1212)
End Sub
Private Sub Find(abab As Integer, aabb As Integer, aaa As Integer)
Dim arr() As String, sFile As String, i As Long
Dim Result As String
Open "c:\1.txt" For Binary As #1 '你的手机号文件
sFile = Space(LOF(1))
Get #1, , sFile
Close #1
arr = Split(sFile, vbCrLf)
For i = 0 To UBound(arr) - 1 '如果txt文件最后一行没有空格时去掉-1
If InStr(arr(i), abab) > 0 Or InStr(arr(i), aabb) > 0 Or InStr(arr(i), aaa) Then
Result = Result & arr(i) & vbCrLf
End If
Next i
'Debug.Print Result
MsgBox Result
End Sub
Public Function iStr(ByVal s As String)
Dim i As Integer
Dim a1, a2, a3, a4, s1 As Integer
For i = 1 To Len(s) - 2
s1 = Mid(s, i, 3)
a1 = Mid(s1, 1, 1)
a2 = Mid(s1, 2, 1)
a3 = Mid(s1, 3, 1)
If a1 = a2 And a3 = a2 Then
Debug.Print s1
End If
Next
For i = 1 To Len(s) - 3
s1 = Mid(s, i, 4)
a1 = Mid(s1, 1, 1)
a2 = Mid(s1, 2, 1)
a3 = Mid(s1, 3, 1)
a4 = Mid(s1, 4, 1)
If a1 = a2 And a3 = a4 Then
Debug.Print s1
End If
Next
For i = 1 To Len(s) - 3
s1 = Mid(s, i, 4)
a1 = Mid(s1, 1, 2)
a2 = Mid(s1, 3, 2)
If a1 = a2 Then
Debug.Print s1
End If
Next
End Function
Private Sub Form_Load()
iStr "13134433555"
End Sub