Extracting a substring from a multi line string.
628524Apr 9 2008 — edited Apr 10 2008My table contains a varchar column name TEXT(2000).I have the following value in one row for this column as:
'A little brown fox jumps over the('hjjhhjhfjhkjhjkfhjkhkjhgjhjkhjkhjkhjkhkjhjkh
jhkgjshjkhkjhjhkjhkjhjhjhjhkjhjhhhhjhjhkjhkjhjhjkhjkhjkhkjhkjhkjhkjhkjhkjhkjhkj
jjjbjbjnbnbnbnmbmnbmnbmnbmnbnmbnmbbbbbbmmmm');lazy dog.
I want to extract the following substr from this example as:
('hjjhhjhfjhkjhjkfhjkhkjhgjhjkhjkhjkhjkhkjhjkh
jhkgjshjkhkjhjhkjhkjhjhjhjhkjhjhhhhjhjhkjhkjhjhjkhjkhjkhkjhkjhkjhkjhkjhkjhkjhkj
jjjbjbjnbnbnbnmbmnbmnbmnbmnbnmbnmbbbbbbmmmm');
Since this particular substr goes into multiple lines,i am facing problem in extracting the same.I am using REGEXT_SUBSTR for the same.
Pls suggest
-MS