topic Re: Field calculator to extract string in ArcGIS Pro Questions

Field calculator to extract string

ALBJORGUI — Fri, 17 Jan 2025 10:59:03 GMT

Hi all, I am trying to get field calculator to help me extract a string from a field and calculate in another field.

Name	Info
ABCDEFG_(0.2014HA)	!Place!.split('(')[1].split(')')[0]
ABCDEFG (TESTXX) (123HA)	??

So for the first field the calculation will get me the value in brackets so I end up with 0.2014HA which is great.

How would I do it for the second one? I want to extract only what is in the second bracket and ignore the first one

Thanks a lot in advance!

Re: Field calculator to extract string

DanPatterson — Fri, 17 Jan 2025 11:27:18 GMT

a = 'ABCDEFG_(0.2014HA)' b = 'ABCDEFG (TESTXX) (123HA)' a[a.find("("):].split(" ")[-1][1:-1] '0.2014HA' b[b.find("("):].split(" ")[-1][1:-1] '123HA' # ---- yielding a code block for your 'fld' def splitter(fld): """Split on a unique case""" val = fld[fld.find("("):].split(" ")[-1][1:-1] return val splitter(a) '0.2014HA' splitter(b) '123HA'

morning brain refresher

Re: Field calculator to extract string

ALBJORGUI — Fri, 17 Jan 2025 11:38:27 GMT

I found another way of doing it too.

!Name!.split('(')[2].split(')')[0]

Re: Field calculator to extract string

DanPatterson — Fri, 17 Jan 2025 15:12:51 GMT

True, but yours fails for the first case

a.split('(')[2].split(')')[0] Traceback (most recent call last): Cell In[3], line 1 a.split('(')[2].split(')')[0] IndexError: list index out of range b.split('(')[2].split(')')[0] '123HA'

where as the function in my example works for both