title: Oracle 11G REGEXP_SUBSTR function
body: <p>I have a data like.  </p>
  
  <blockquote>
    <p>"sometext"  HostAddress: 10.10.10.100 / 198.168.34.63 "sometext"
    "newline" "sometext"  HostAddress: 10.10.10.100 "sometext" "newline"</p>
  </blockquote>
  
  <p>using REGEXPR_SUBSTRING I am able to achieve HostAddress: 10.10.10.100 ie. first object adjacent to HostAddress: string.but not second string i.e 1998.168.34.63 I want to output like HostAddress: IP / IP using Regexp_substr function.</p>
  
  <p>I am using below function to obtain specified filed from row data. </p>
  
  <pre><code>   SELECT REGEXP_SUBSTR('HostAddress: 10.10.10.100 / 198.168.34.63 sometext','HostAddress: ([[:alnum:]]+\.?){3,4} ') FROM Dual;
  </code></pre>
  
  <p>Thank you in advance ...... </p>