title: How do I extract text from string between 2 words in Oracle
body: <p>I would like to get the text between 2 words from a string.
  the <code>GROUP TITLE</code> is between <code>GROUP TITLE</code> and <code>DURATION</code>
  <code>Group Title:  Goal Setting Duration: 60 minute</code>
  I would like the results to be in a separate column and <code>DURATION</code> in another column. </p>
  
  <p>I am using the following, but its not a consistent position in the string and i get part of additional text when i use the following</p>
  
  <pre><code>CASE WHEN A.NOTE_TEXT like 'Group Title:%' 
  then SUBSTR(A.NOTE_TEXT,INSTR(A.NOTE_TEXT,'Group Title:',1),55) END AS GROUP_TITLE,*
  </code></pre>
  
  <p>My results would look like </p>
  
  <pre><code>GROUP TITLE                   |  DURATION
  Group Title: Goal Setting     |  Duration: 60 minutes      
  Group Title: Mood Management  |  Duration: 90 minutes
  </code></pre>
  
  <p>How can i get only the text for <code>GROUP TITLE</code> column from <code>GROUP TITLE: TITLE OF GROUP REPORT</code> to <code>DURATION</code>? </p>
  
  <p>any help would be appreciated. 
  thank you</p>