regexp_substr to get String between a string value and pipe

Question

need regexp_substr for finding a string value between a string and a pipe

Example 1

'blah,blah...|text=1234|nmbnxcm'

Result 1:

Example 2

'test,test...|text=4321|testing'

Result 2

Jeff Holt · Accepted Answer · 2017-07-18 15:04:02Z

2

If this doesn't help, then please try this, assuming there is only one occurrence of what you want from the source string.

select to_number(regexp_substr('blah,blah...|text=1234|nmbnxcm', '|text=([0-9]+)|', 1, 1, null, 1))
from dual;

The to_number wouldn't be required but is a bit more intentional w.r.t. the given RE.

answered Jul 18, 2017 at 15:04

Jeff Holt

3,2623 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1