title: Extracting a (sub)string from within parentheses
body: <p>I'm trying to extract text from within parentheses inside of a string. Example:</p>
  
  <pre><code>"John D Wilson(some text)"
  </code></pre>
  
  <p>I want to extract only <code>some text</code> from the string.</p>
  
  <p>Here is the code I have so far: </p>
  
  <pre><code>temp = workingValue
  rawname=split(temp)
  dim value
  Set myRegExp = New RegExp
  myRegExp.IgnoreCase = True
  myRegExp.Global = True
  
  myRegExp.Pattern = "/\([a-z]+\)/"
  msgbox temp
  if myRegExp.Test(temp)then
  value = myRegExp.Replace(temp,"")
  msgbox value
  else
  msgbox "no match"
  end if
  </code></pre>