topic Re: Range string and number in ArcGIS Pro Questions

Range string and number

Greta — Mon, 29 Nov 2021 07:22:17 GMT

I have a set of overlapping points (1X, 20Z, 1A, 50D, 2B), and I would like to get the min and max values Min: 1A, Max: 50D.
The tool "Summarize attribute" get the min and max of integer.
How do you get the min and max of string + integer automatically?
Would you please let me know if there are any tools or codes available?
Thanks

Range string and number

Greta — Mon, 29 Nov 2021 07:21:48 GMT

Re: Range string and number

DanPatterson — Mon, 29 Nov 2021 09:17:36 GMT

How to extract numbers from a string in Python? - Stack Overflow

That will handle the splitting but not more simply

value = "20Z"

int(value[:-1])

will yield the number part.

Your problem is that you will have to process this to provide 2 arrays, which you can use to summarize by letter. OR if you don't care about the letter, then just take the min and max of the overlapping points with the new integer identifier

Re: Range string and number

JoshuaBixby — Mon, 29 Nov 2021 15:25:05 GMT

@Greta, I am not sure why you re-posted your original question as a reply to Dan's comment. I suggest you either change the reply or simply delete it since it currently adds no value to the discussion.

Re: Range string and number

DanPatterson — Mon, 29 Nov 2021 17:51:42 GMT

it was a double-post so I merged them Josh

Re: Range string and number

Greta — Tue, 30 Nov 2021 09:54:45 GMT

thank you I will try