Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Simple REGEXP_SUBSTR question

lsy_nnJan 6 2014 — edited Jan 6 2014

Hi All,

And I know that should be simple

How to substr from given (double underscore delimited) string up to delimiter using regexp_substr:

'DocumentName:KC51351 - Employee Letter of Consent (code 407)__DocumentOwner:Georgio Vuolde__DocumentExpireDate:1/1/2015 120000 AM'

I 'm looking for everything between  'DocumentOwner:' and  '__' (double underscore)

'Georgio Vuolde' in this case.


Please note there are could be single underscores in the given field.


Thanks a lot for your help,

LSY.
This post has been answered by Frank Kulash on Jan 6 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2014
Added on Jan 6 2014
5 comments
245 views