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

Hi,

 

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.

 

TextStringAttributes.png

Outcomes