Field calculator to extract string

Question

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

NameInfoABCDEFG_(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!

danretired · Accepted Answer

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

ALBJORGUI · Accepted Answer

I found another way of doing it too.

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