Re: Regular Expressions; return a buried match
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 3 Feb 2010 16:14:08 -0700
Message-ID: <4b6a1150$1_at_news.victoria.tc.ca>
cate (catebekensail_at_yahoo.com) wrote:
: select REGEXP_SUBSTR(encodedField, '^\d{4}(\d\d)') from table;
Date: 3 Feb 2010 16:14:08 -0700
Message-ID: <4b6a1150$1_at_news.victoria.tc.ca>
cate (catebekensail_at_yahoo.com) wrote:
: select REGEXP_SUBSTR(encodedField, '^\d{4}(\d\d)') from table;
: I want the 5th and 6th digit. Can Oracle do this?
In 10GR1 not directly in one regexp. In this case substr(result,5,2) would help. In other versions with regexp's I assume the same, but you could always check yourself
google: REGEXP_SUBSTR 10GR2 download Received on Wed Feb 03 2010 - 17:14:08 CST