AnsweredAssumed Answered

Select attributes that ends in numbers

Question asked by CCweedcontrol on Jun 24, 2016
Latest reply on Jun 29, 2016 by Dan_Patterson

I have a feature class and in that feature class i have a field "SiteAddress" and most attributes t looks good but there are some attributes that have numbers after the address and they are not suite, unit or apartment numbers. I am trying to figure out how to query to select them.

 

Example of one is 24832 Trunnel Ct 8693, is there a way to select features with numbers after alphabet characters and delete the 8693 from ones that have the numbers after the alphabet characters.

 

any help would be great.

Thanks.

Outcomes