nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom parse Python string

JeremyMcCollum1

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

Find more posts tagged with

Accepted answers

DanPatterson_Retired

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')

All comments

DanPatterson_Retired

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')

JeremyMcCollum1

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

DanPatterson_Retired

for the visual types...

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

JeremyMcCollum1

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

JeremyMcCollum1

DanPatterson_Retired

show an example.

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

JeremyMcCollum1

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

DanPatterson_Retired

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 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'VILLAGES OF WOODLAND SPRINGS BLOCK 44 LOT 4'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'FIVE OAKS CROSSING ADDN BLOCK 1 LOT 6 PER PLAT D214124070'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'SUMMER CREEK SOUTH ADDITION BLOCK 8 LOT 3'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">do_stuff</SPAN><SPAN class="punctuation token">(</SPAN>a_val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""call using do_stuff(!Your_fld!)"""</SPAN>
    row <SPAN class="operator token">=</SPAN> a_val<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN>
    idx0 <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BLOCK'</SPAN><SPAN class="punctuation token">)</SPAN>
    idx1 <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LOT'</SPAN><SPAN class="punctuation token">)</SPAN>
    out <SPAN class="operator token">=</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN>idx1<SPAN class="punctuation token">:</SPAN>idx1<SPAN class="operator token">+</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> row<SPAN class="punctuation token">[</SPAN>idx0<SPAN class="punctuation token">:</SPAN>idx0<SPAN class="operator token">+</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> out
    

<SPAN class="keyword token">for</SPAN> a_val <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">:</SPAN>
    returned <SPAN class="operator token">=</SPAN> do_stuff<SPAN class="punctuation token">(</SPAN>a_val<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>returned<SPAN class="punctuation token">)</SPAN>
    
LOT <SPAN class="number token">4</SPAN> BLOCK <SPAN class="number token">44</SPAN>
LOT <SPAN class="number token">6</SPAN> BLOCK <SPAN class="number token">1</SPAN>
LOT <SPAN class="number token">3</SPAN> BLOCK <SPAN class="number token">8</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

bixb0012

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> re
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> strings <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     <SPAN class="string token">"VILLAGES OF WOODLAND SPRINGS BLOCK 44 LOT 4"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     <SPAN class="string token">"FIVE OAKS CROSSING ADDN BLOCK 1 LOT 6 PER PLAT D214124070"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     <SPAN class="string token">"SUMMER CREEK SOUTH ADDITION BLOCK 8 LOT 3"</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> 
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">for</SPAN> s <SPAN class="keyword token">in</SPAN> strings<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>re<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'(BLOCK|LOT) (\S*) ?'</SPAN><SPAN class="punctuation token">,</SPAN>s<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BLOCK'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'44'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LOT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BLOCK'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LOT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'6'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BLOCK'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LOT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'3'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.