Retrieving certain strings within a string using Oracle SQL - Part 2

Question

Unfortunately I having a few issues now trying to get this going as my data has changed based on an original thread I started see:

Retrieving certain strings within a string using Oracle SQL

My data has now changed to look like:

member_of = CN=DAaXYZApple-Au, CN=DAaXYZApple-Readonly, CN=aXYZApple-Write, CN=DAaXYZApple-Au-Admin, CN=aTest123_RW, {CN=# XXY22,} CN=aInternet-1

Using the same type of techniques described in my original post, I need to obtain all strings that hold the string "aXYZApple" only. So based on the above, the following results is what I am after and would be displayed only:

aXYZApple-Au
aXYZApple-Readonly
aXYZApple-Write
aXYZApple-Au-Admin

I am unsure if I still need to use Oracle regexp_substr as in my original post.

I have managed to solve this issue - no longer require assistance. — tonyf
– tonyf, Commented Jun 13, 2012 at 2:51
As @Pedantic mentioned - please post the solution as an answer. You can aceept it later on — Sathyajith Bhat
– Sathyajith Bhat, Commented Jun 13, 2012 at 7:36

tonyf · Accepted Answer · 2012-06-14 03:31:16Z

1

The solution for my own question based on updated dataset is as follows, which is pretty much based on the solution provided to me in my original question, i.e.:

SELECT regexp_substr(line, 'aXYZApple[^,]*') subtxt
FROM (SELECT regexp_substr(:x, '[^,]*\,', 1, rownum + 1) line
      FROM dual
      CONNECT BY LEVEL <= length(:x) - length(REPLACE(:x, ',', '')))
WHERE line LIKE '%aXYZApple%';

answered Jun 14, 2012 at 3:31

tonyf

35.8k54 gold badges168 silver badges265 bronze badges

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

Collectives™ on Stack Overflow

Retrieving certain strings within a string using Oracle SQL - Part 2

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related