extract data from column containg clob

I have a column in a table that contains a clob. i need to extract data from the clob that starts with "Area=". So for example the clob looks like :
"LEC=XO, BTN=333-666-1111
Sourcebook and VoIP Discovery available.
Area= CapitalMetro, District= Greensboro"

I just need the info after Area=. so in this case CapitalMetro.
Please advise/assist
thanks,
Mike

You need to use the DBMS_LOB package for this. There is a instr function as well as a substr function. You probably want some kind of regular expression.