I will check it up,Thanks
>>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','',')')
>>
>>
>>But in some cases I have Data as
>>
>>
>>cCustomerType=STREXTRACT('F1 B (Customer Type RETIRED DOT )396 680 w','',')')
>>cCustomerType=STREXTRACT('F1 B (Customer Type RETIRED DOT)396 680 w','',')')
>>cCustomerType=STREXTRACT('F1 B (Customer Type SL RETIRED DOT)396 680 w','',')')
>>
>>
>>i.e I need Everything inside the the Two brackets except Customer Type. Does STREXTCAT can be used in above cases. How ?
>>
>>Regrards
>>Harsh
>
>Here's a try:
>
>cCustomerType = alltrim(strextract('F1 B (Customer Type SL RETIRED DOT)396 680 w',"Customer Type",")"))
>
>There might be other variability you haven't described, but this works for the 3 instances you mentioned.
>
>hth,
>
>Hank
Harsh