AnsweredAssumed Answered

How do I select by attribute to get the numbers from the attribute table list that has mixed strings/numbers ?

Question asked by progis99 on Mar 8, 2016
Latest reply on Mar 22, 2016 by progis99



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.