适用于文本数据库
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