Query to have only numeric values in the field

Question

I have a feature class and one of its fields is Route type. I need to exclude from this Feature class all Routes that have any letter in the value (my values are 1203,1234,123B, BB and etc) I should have only numeric ones.

How can I do it in my Python code?

Thank you in advance!!!!

DanPatterson_Retired · Answer

the part where I said add the field and ...

* use the python parser, and calculate    int( !YourFieldWithClasses!.isdigit())

yes

Not the part about cycling through featureclasses, adding the field and doing the calculation manually... that is the scripting part

Which is why I said try it manually and if you like it then do some reading and it can be scripted...with help probably

LianaSmith · Answer

Can I do it simpler using Field Calculator and writing small code there?

DanPatterson_Retired · Answer

Ok... so do you know how to

* list featureclasses    ListFeatureClasses—Help | ArcGIS for Desktop
* get a featureclass from the list
* get a list of fields , ListFields—Help | ArcGIS for Desktop
* then get a field from that list?
* Then... cycle through the records that don't have a number in them?

A little much and you are already jumping to batches.

What I might suggest for the interim for checking is the following

* add a field to the feature classes table, called test, make it an integer field
* using the field calculator, calculate values for that new field using the following idea
* use the python parser, and calculate    int( !YourFieldWithClasses!.isdigit())
* this will produce a field of 0 or 1 as in the example below
*

>>> a = "123456bb345"

>>> int(a.isdigit())

0

>>> a = "123456"

>>> int(a.isdigit())

1

Now if you just manually query the field for 1, then they are all the good fields and you can export them to a new feature class.

If you like that, it will save a bunch of stuff that you probably don't want to do now if you are learning.  If it works and it seems easy, then the next stage is coding.