topic Re: Splitting text strings in Python Questions

Splitting text strings

Anonymous User — Mon, 02 Jul 2012 12:39:13 GMT

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

Re: Splitting text strings

markdenil — Sun, 12 Dec 2021 08:25:21 GMT

There is indeed a length test: len()

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

Re: Splitting text strings

JakeSkinner — Mon, 02 Jul 2012 15:15:24 GMT

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

Re: Splitting text strings

Anonymous User — Mon, 02 Jul 2012 15:23:22 GMT

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

Re: Splitting text strings

Anonymous User — Mon, 02 Jul 2012 15:25:21 GMT

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

Re: Splitting text strings

Anonymous User — Fri, 27 Jul 2012 15:39:18 GMT

Jake,

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

Caleb