title: xQuery substring problem
body: <p>I now have a full path for a file as a string like:</p>
  
  <pre><code>   "/db/Liebherr/Content_Repository/Techpubs/Topics/HyraulicPowerDistribution/Released/TRN_282C_HYD_MOD_1_Drive_Shaft_Rev000.xml" 
  </code></pre>
  
  <p>However, now I need to take out only the folder path, so it will be the above string without the last back slash content like:</p>
  
  <pre><code>"/db/Liebherr/Content_Repository/Techpubs/Topics/HyraulicPowerDistribution/Released/"
  </code></pre>
  
  <p>But it seems that the substring() function in xQuery only has substring(string,start,len) or substring(string,start), I am trying to figure out a way to specify the last occurence of the backslash, but no luck.</p>
  
  <p>Could experts help? Thanks!</p>