title: Extract substring using importxml and substring-after
body: <p>Using Google sheet 'ImportXML', I was able to extract the following data from a url(in cell A2) using:</p>
  
  <pre><code>=IMPORTXML(A2,"//a/@href[substring-after(., 'AGX:')]").
  </code></pre>
  
  <p>Data: </p>
  
  <pre><code>/vector/AGX:5WH
  /vector/AGX:Z74
  /vector/AGX:C52
  /vector/AGX:A27
  /vector/AGX:C6L
  </code></pre>
  
  <p>But, I want to extract the code after "/vector/AGX:". The code is not fixed to 3 letters and number of rows is not fixed as well.</p>
  
  <p>I used <code>=INDEX(SPLIT(AP2,"/,'vector',':'"),1,2)</code>. But it applied to only one line of data. Had to copy the index+split function to the whole column and had to insert an additional column to store the codes.</p>
  
  <pre><code>5WH
  Z74
  C52
  A27
  C6L
  </code></pre>
  
  <p>But, I want to be able to extract the code(s) after AGX: using ImportXML in one go. Is there a way? </p>