I have imported CAD annotation and changed it to point feature, and I have the "text string" field in table attribute. Now I want to filter any records that contain the text in parentheses. For example: the text is "100PVC (2005)" => I want to get "2005" But the field is more complicated than this example, because some records just like "(05-07)". I have tried the index function with field calculator but it did not work. I also could not select records which contain the parentheses by using the Select by Attributes. My expression was:
[TextString] LIKE '%(____)%'
When I verify that it was successfully but no records were returned.
How can I solve this problem?