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; } } }

Splitting text strings

Anonymous User

I am working on an addressing project for my county and I am trying to split an address field from parcel data that we have. I have been using the !Field!.split(" ")[0] function to split them by spaces. The problem is I want to get street names that have 2 and 3 words to be separate from the N, S, E, and W prefixes and not all of the records in the field have the N or S before the street name so doing it by order of the spaces is not really going to work. I am wondering if there is any sort of .length() type function to select only one letter parts of a record in a string (the N, S, E, or W) and put it into a field by itself so I know which addresses I need to populate the prefix for? Or what is the best way to split fields when I have street names like Valley Forge Dr, N Main St, and King Ave? I need the direction in one field, the street name in another (one and two word street names), and the suffix in the last field. I know to get just the suffix I can use the !Field!.split(" ")[-1], but is it possible to just get the prefix from the records that have one? If anyone can help please let me know! Thanks!

Caleb
GIS Technician
Cedar County, IA

Finde mehr Beiträge mit dem Tag

Accepted answers

jskinner

Here are a couple functions you can use to get the prefix, street name, and suffix. You would need to make some minor changes to get this to work in the field calculator.

def prefix():     rows = arcpy.UpdateCursor(table)     for row in rows:         if len(row.FullAddr.split(" ")[0]) == 1:             row.Prefix = row.FullAddr[0]             rows.updateRow(row)     del row, rows  def suffix():     rows = arcpy.UpdateCursor(table)     for row in rows:         row.Suffix = row.FullAddr.split(" ")[-1]         rows.updateRow(row)     del row, rows  def street():     rows = arcpy.UpdateCursor(table)     for row in rows:         if len(row.FullAddr.split(" ")[0]) == 1:             row.Street = ' '.join(row.FullAddr.split(" ")[1:-1])             rows.updateRow(row)         else:             row.Street = ' '.join(row.FullAddr.split(" ")[0:-1])             rows.updateRow(row)     del rows, row  prefix() suffix() street()

All comments

Anonymous User

Jake,

Thank you very much for that update cursor! It worked like a charm!

Caleb

Anonymous User

And thank you Jake, I just now saw your reply. I will try this and see if I can get it to work. I am no expert with python so I will see how much of this code I can understand and try to modify it to work.

Caleb

Anonymous User

Thank you for the quick response...However, I am still having problems with it. This could be because I am pretty new to python but I threw this into the field calculator and it gave me the errors with geoprocessing message:

if len(!ADDRESS!.split(" ")[0]) == 1

This did not work for some reason. Any other suggestions? For beginners? 🙂

Caleb

jskinner

Here are a couple functions you can use to get the prefix, street name, and suffix. You would need to make some minor changes to get this to work in the field calculator.

def prefix():     rows = arcpy.UpdateCursor(table)     for row in rows:         if len(row.FullAddr.split(" ")[0]) == 1:             row.Prefix = row.FullAddr[0]             rows.updateRow(row)     del row, rows  def suffix():     rows = arcpy.UpdateCursor(table)     for row in rows:         row.Suffix = row.FullAddr.split(" ")[-1]         rows.updateRow(row)     del row, rows  def street():     rows = arcpy.UpdateCursor(table)     for row in rows:         if len(row.FullAddr.split(" ")[0]) == 1:             row.Street = ' '.join(row.FullAddr.split(" ")[1:-1])             rows.updateRow(row)         else:             row.Street = ' '.join(row.FullAddr.split(" ")[0:-1])             rows.updateRow(row)     del rows, row  prefix() suffix() street()

markdenil

There is indeed a length test: len()

if len(!Field!.split(" ")[0]) == 1:
    you have a one letter prefix

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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