topic Re: Right Trim String after Special Char in Python Questions

Right Trim String after Special Char

John_S — Fri, 25 Feb 2011 17:45:35 GMT

Ok, so I know it's probably something really simple that I'm missing, but, I need some help getting this to work.
I've got an attribute field !ADDRESS_GEO!. This is a text field that has addresses in it, but they were user submitted addresses that include ";" and "#" type information. An example address would be "123 W Main St ; STE 120" and "234 E Main St #D". To geocode these using the geocode service I've got, I have to strip out the ";" and "#" characters as well as anything to the right of them and ideally leading and trailing spaces from the resulting string. I'm using the Calculate Field geoprocessing tool in 9.3.1 Sp2. I've tried a couple of expressions I thought would work to no avail, so, if anyone can help...

I've tried the expressions:
!ADDRESS_GEO!.rstrip(';')

and

!ADDRESS_GEO![:(!ADDRESS_GEO!.find(';'))]

If it makes any difference, the error I'm getting is:

"ERROR 000539: Error running expression: [:(.find(';'))] <type 'exceptions.SyntaxError'>: invalid syntax (<string>, line 1)"

Re: Right Trim String after Special Char

ChrisMathers — Fri, 25 Feb 2011 18:52:13 GMT

try !ADDRESS_GEO!.split(';')[0]

Re: Right Trim String after Special Char

John_S — Fri, 25 Feb 2011 19:43:22 GMT

I Tried and got the error:

"ERROR 000539: Error running expression: .split(';')[0] <type 'exceptions.SyntaxError'>: invalid syntax (<string>, line 1)
Failed to execute (CalculateField)."

Re: Right Trim String after Special Char

ChrisMathers — Fri, 25 Feb 2011 20:00:54 GMT

Uhh I hate trying things like this in the calculator. Get the python window out and just use an update cursor. Try this.

import arcpy
cursor=arcpy.UpdateCursor(yourFC)
for row in cursor:
row.ADDRESS_GEO=row.ADDRESS_GEO.split(';')[0]
cursor.updateRow(row)
del cursor

Re: Right Trim String after Special Char

John_S — Fri, 25 Feb 2011 20:15:13 GMT

I'm still in Desktop 9.3.1, does arcpy actually work in 9.3.1? I thought that was only at 10.
If only I could use a simple update cursor.

Re: Right Trim String after Special Char

John_S — Fri, 25 Feb 2011 21:21:39 GMT

Thanks for all your suggestions and help. I honestly have no earthly clue what was wrong with any of the above mentioned efforts to resolve the issue, but, I did manage to finally work out an "~ish" work-around that involved
export to Excel > text to columns tool > delete extra new columns > import Excel table into Database > create join based on ObjID (included in export to Excel) > calculate field in original table to match corrected field in joined table

I really would still love to figure out some effective calculate expression to resolve this quickly all within the database (since I will have to do this somewhat regularly for a new project I got), but, I guess I may have to wait on that until I am allowed by my 3rd party extensions to upgrade to V10 so I can use arcpy.

Thanks again for the suggestions.

Re: Right Trim String after Special Char

DanPatterson_Retired — Sat, 11 Dec 2021 08:51:38 GMT

parser: Python
Prelogic code section

def split_string(a_field):
  return a_field.split(";")[0]

expression section
split_string(!textfield!) #where !textField! is the field you are trying to split

Re: Right Trim String after Special Char

KennethBrevard — Sat, 11 Dec 2021 08:51:40 GMT

Just to add on to this if anyone else stumbles across this thread trying to reverse concatenate a field.
I needed a simplified way to trim/split address numbers from a string in Python in the field calculator. For example, for "199 MAIN ST" I needed returned "MAIN ST".
Many ways to skin a cat but this can be done with an extension of the code provided above:

def split_string(a_field):
  return a_field.split(" ", 1)[1]

Codeblock:
split_string(!MY_FIELD!)