Split a column/field

[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

[Adsters]

sorry I should have mentioned using sqlplus

[PAVB]

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...

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