Split a column/field

OK,

I have a field where the values are like so

#TASK CPH-555#
#TASK CPH-546# #TASK CPH-576#
#TASK CPH-766# some blah blah
#TASK ADB-756# some blah blah #TASK CPH-57#
some blah blah #TASK CPH-987#
#TASK CPH-756# #TASK ABD-764# #TASK CPH-888"

Now, I need to split this field and extract only the "CPH-nnn" or the ADB-nn" parts of the text string.

Any ideas,

Thanks in advance

sorry I should have mentioned using sqlplus

Quote:

---

Originally Posted by Adsters

OK,

I have a field where the values are like so

#TASK CPH-555#
#TASK CPH-546# #TASK CPH-576#
#TASK CPH-766# some blah blah
#TASK ADB-756# some blah blah #TASK CPH-57#
some blah blah #TASK CPH-987#
#TASK CPH-756# #TASK ABD-764# #TASK CPH-888"

Now, I need to split this field and extract only the "CPH-nnn" or the ADB-nn" parts of the text string.

Any ideas,

Thanks in advance

---

This may point you in the right direction...

Code:

---

select  SUBSTR('#TASK CPH-555# blah blah blah',
        (INSTR('#TASK CPH-555# blah blah blah','CPH')),
        7)  "EXTRACTED VALUE"
from    DUAL
;

---