title: XSLT to return string between two characters
body: <p>I am trying to return part of a string in an XML sheet.
  I want to keep what is between the brackets in the "Description" field, and move what is outside the brackets to a different field:</p>
  
  <p>The Source XML:</p>
  
  <pre><code>&lt;Log&gt;
     &lt;Date&gt;15-Nov-2014&lt;/Date&gt;
     &lt;TC&gt;14:38:47:13&lt;/TC&gt;
     &lt;Description&gt;Move this text (but keep this text here)&lt;/Description&gt;
  &lt;/Log&gt;
  </code></pre>
  
  <p>Desired result is:</p>
  
  <pre><code>&lt;Log&gt;
     &lt;Date&gt;15-Nov-2014&lt;/Date&gt;
     &lt;TC&gt;14:38:47:13&lt;/TC&gt;
     &lt;Description&gt;but keep this text here&lt;/Description&gt;
     &lt;MyOtherField&gt;Move this text&lt;/MyOtherField&gt; 
  &lt;/Log&gt;
  </code></pre>
  
  <p>I have tried using the substring-before "(" and 'substring-after ")" functions in line and the output is almost correct - however the snag is that not all the "Description" fields in my source XML sheet have text in brackets, so those are being deleted completely.</p>
  
  <p>Any assistance would be greatly appreciated.</p>
  
  <p>Thank you</p>