I am using STREXTRACT to Extract Data from String. Using the following code I am Getting my Required Data but in some cases as the Data format change STREXTRACT () returns an empty value. Can STREXTRACT can be used to extract Data in both the cases, if whats the best alternative ?

cCustomerType=STREXTRACT('F1 B (Customer Type            RETIRED)396 680 w','',')') && returns RETIRED as required Value correct 

But in some cases I have Data as

cCustomerType=STREXTRACT('F1 B (Customer Type            RETIRED DOT )396 680 w','',')') && returns Empty Value
cCustomerType=STREXTRACT('F1 B (Customer Type            RETIRED DOT)396 680 w','',')') && returns Only DOT and I need RETIRED DOT
cCustomerType=STREXTRACT('F1 B (Customer Type          SL  RETIRED DOT)396 680 w','',')') && returns Only DOT and I need SL RETIRED DOT

i.e I need Everything inside the the Two brackets except Customer Type. Does STREXTCAT can be used in above cases. How ?

Regrards
Harsh