title: How can I get a substring from the middle of a file path in VBScript?
body: <p>I have the following string in VBScript:</p>
  
  <pre><code>myPath = "C:\Movies\12 Monkeys\12_MONKEYS.ISO"
  </code></pre>
  
  <p>The path C:\Movies\ is always going to be the same. So here is another path as an example:</p>
  
  <pre><code>myPath = "C:\Movies\The Avengers\DISC_1.ISO"
  </code></pre>
  
  <p>My question is, how can I pull only the movie folder name, so in the above examples I would get:</p>
  
  <pre><code>myMovie = "12 Monkeys"
  myMovie = "The Avengers"
  </code></pre>
  
  <p>Is there a way to use RegEx with this? Or should I just do some substring and index calls? What is the easiest way to do this?</p>