适用于文本数据库
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile("Test.txt",1)
While not f.AtEndOfStream
strR = f.ReadLine
if instr(strR,"AA") > 0 Then
strR = Split(strR,"(")
str = Split(strR(1),")")
msgbox str(0)
End If
Wend
f.Close
For text database
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile("Test.txt",1)
While not f.AtEndOfStream
strR = f.ReadLine
if instr(strR,"AA") > 0 Then
strR = Split(strR,"(")
str = Split(strR(1),")")
msgbox str(0)
End If
Wend
f.Close