Formattin item description column

[AIMAM]

hi,

I need help with formatting a column <b>item description </b> varchar2(240) <b>APPS.PO_LINES</b> table where it contains data like the following:

1. OSP FIBER ACCESSORY-CLOSURE-FIBER-48 F-CAPITAL-NONE-NONE
2. OSP PVC-PVC PIPE-NONE-50 M.M-CAPITAL-NONE-NONE
3. OSP PVC ACCESSORY-BEND PIPE-BEND PIPE 90 DGREE-100 M.M-CAPITAL-NONE-NONE
4. Work manship

I need to format the column in a select statement in such a way that it excludes the the last three<b> -CAPITAL-NONE-NONE</b> when the column contains them.



Any idea?