AnsweredAssumed Answered

Select the highest of similar values

Question asked by gambrels on Apr 30, 2013
Latest reply on May 2, 2013 by rfairhur24
Hi folks,

I am looking for a tool that I can use to select the highest value within a set of similar values.   

The values are alphanumeric, and are essentially two parts merged into one field - a master ID to the left of a decimal and a segment ID to the right of the decimal.   Each "master" has a different number of segments.  I would like to select the feature with the higest segment ID for each unique master ID.  There are roughly 5000 unique values in this field.    

For instance, in a series of AB1.1, AB1.2, AB1.3, YZ4.1, YZ4.2, both AB1.3and YZ4.2 would be selected.    


I would prefer to do this operation with the out-of-the- box functionality & GP tools, but could work with Python if necessary (I am an absolute novice).  Any suggestions on how to approach this??

Thanks!!
Sean

Outcomes