string function question in pl/sql

jl66
jl66 used Ask the Experts™
on
Have a string around 500 characters long, in which there is something like '...'. For example,

A String like

This is a special string, which contains some single quotation marks. 'Mark: we want to get the whole thing within the single quotation mark.' This is all we want to do.

How to get the substring out:

Mark: we want to get the whole thing within the single quotation mark.

Assume that the string is around 500 characters long.

Can any guru shed some light on it? Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
Commented:
Regexp_substr(yourstring,'''[^'']+''')
Most Valuable Expert 2011
Top Expert 2012

Commented:
All of the quotes in the above post are single quotes
jl66Consultant

Author

Commented:
Appreciate your prompt help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial