cCustomerType=STREXTRACT('F1 B (Customer Type RETIRED)396 680 w','',')') && returns RETIRED as required Value correctBut 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 DOTi.e I need Everything inside the the Two brackets except Customer Type. Does STREXTCAT can be used in above cases. How ?