topic Re: Custom parse Python string in Developers Questions

Custom parse Python string

JeremyMcCollum1 — Tue, 12 Mar 2019 21:47:09 GMT

I have an attribute field that has a description that I only want to display a specific string or text. I'm not sure if using a rsearch or rfind or another method for displaying what I want is best? For example, the text field:

VILLAGES OF WOODLAND SPRINGS BLOCK 44 LOT 4

FIVE OAKS CROSSING ADDN BLOCK 1 LOT 6 PER PLAT D214124070

SUMMER CREEK SOUTH ADDITION BLOCK 8 LOT 3

I am only wanting to pull out the Block and block number and Lot and Lot number

thanks for any advice

Re: Custom parse Python string

JoshuaBixby — Sun, 12 Dec 2021 09:01:23 GMT

>>> import re
... 
... strings = [
...     "VILLAGES OF WOODLAND SPRINGS BLOCK 44 LOT 4",
...     "FIVE OAKS CROSSING ADDN BLOCK 1 LOT 6 PER PLAT D214124070",
...     "SUMMER CREEK SOUTH ADDITION BLOCK 8 LOT 3"
... ]
... 
>>> 
>>> for s in strings:
...     print(re.findall('(BLOCK|LOT) (\S*) ?',s))
...     
[('BLOCK', '44'), ('LOT', '4')]
[('BLOCK', '1'), ('LOT', '6')]
[('BLOCK', '8'), ('LOT', '3')]
>>> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Custom parse Python string

DanPatterson_Retired — Sun, 12 Dec 2021 09:01:26 GMT

A fake field and a function to try with the field calculator, python parser,

code block is below.

expression line

do_stuff(!YourFieldNameHere!)

lines 14-16 simulate a fake column 'a'

hopefully you get the drift. I wrote it as overtly as possible

a = [ 'VILLAGES OF WOODLAND SPRINGS BLOCK 44 LOT 4',
'FIVE OAKS CROSSING ADDN BLOCK 1 LOT 6 PER PLAT D214124070',
'SUMMER CREEK SOUTH ADDITION BLOCK 8 LOT 3']

def do_stuff(a_val):
    """call using do_stuff(!Your_fld!)"""
    row = a_val.split(" ")
    idx0 = row.index('BLOCK')
    idx1 = row.index('LOT')
    out = " ".join(row[idx1:idx1+2] + row[idx0:idx0+2])
    return out
    

for a_val in a:
    returned = do_stuff(a_val)
    print(returned)
    
LOT 4 BLOCK 44
LOT 6 BLOCK 1
LOT 3 BLOCK 8
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Custom parse Python string

JeremyMcCollum1 — Wed, 13 Mar 2019 14:10:39 GMT

My example that I used actually has lots and lots of blocks and lots with numbers, what could I use to grab them all?

Re: Custom parse Python string

DanPatterson_Retired — Wed, 13 Mar 2019 19:28:12 GMT

show an example.

Is the stuff in a table (see the field calculator example I posted) or what format are they in?

Re: Custom parse Python string

JeremyMcCollum1 — Wed, 13 Mar 2019 20:07:10 GMT

Re: Custom parse Python string

JeremyMcCollum1 — Wed, 13 Mar 2019 20:07:52 GMT

legaldesc is the attribute field that I am looking to do this on

Re: Custom parse Python string

DanPatterson_Retired — Thu, 14 Mar 2019 00:26:28 GMT

add a new text field and try the field calculator code block and expression I posted. python parser code block as above and the expression would be

do_stuff(!legaldesc!)

Re: Custom parse Python string

JeremyMcCollum1 — Mon, 18 Mar 2019 15:14:17 GMT

Can I see how you put this in? I can't get mine to work. I am also doing this in ArgGIS Pro, not sure if that will make a difference

Re: Custom parse Python string

DanPatterson_Retired — Mon, 18 Mar 2019 15:38:50 GMT

for the visual types...

I swapped the code block up so block appears before lot (my bad in the original)

Re: Custom parse Python string

JeremyMcCollum1 — Mon, 18 Mar 2019 21:18:56 GMT

Excellent, it finally did work! I have some cleanup now. Can I add another index to the code to include spaces? For example, there are some of the legaldesc field texts that say BL OCK or B LOCK that have random spaces. Trying now to account for them. Great help thought to get this far

Re: Custom parse Python string

DanPatterson_Retired — Mon, 18 Mar 2019 21:27:36 GMT

Jeremy you might want to mark mine correct.

Now for the ones with the spaces, you will have to modify indx0 for those cases

for example...

idx0 = row.index('BL OCK')