title: Getting a substring from a string (characters in between single quotes) (Python)
body: <p>This is the string I currently have:</p>
  
  <pre><code>URL = "location.href='agent_specific_listing.php?sid=131184&amp;mls=693010&amp;a=103&amp;site_id=540&amp;page_current=1';"
  </code></pre>
  
  <p>I am trying to split the substring by single quotes so that this is the result:</p>
  
  <pre><code>new_url = 'agent_specific_listing.php?sid=131184&amp;mls=693010&amp;a=103&amp;site_id=540&amp;page_current=1'
  </code></pre>
  
  <p>I tried to use re and findall but I got empty string back:</p>
  
  <pre><code>print(re.findall(r"\(u'(.*?)',\)", URL)) // printed empty lists
  </code></pre>
  
  <p>Please let me know what I am doing wrong. Many thanks.</p>