I am not good at Select by Attributes but here I have a layer that has mixed strings/numbers such as 1,2,3,...A,B.C,D,E , etc They came from CAD layer I imported to File Geodatabase as a feature class.
I do know how to do simple query such as TextString = "A" to get all the A's only .
I am trying to select the numbers only from the attribute to export a new feature class. I have to do the same with the lower capitals.
I could have open the attribute and highlighted them but it is time-consuming....
How do I do that ?
Here is the picture sample from the layer.