topic Re: Truncate Address in String Field in Data Management Questions

Truncate Address in String Field

StevenSmith1 — Wed, 24 Oct 2012 13:30:05 GMT

I would like to remove city codes from the end of addresses that need to be geocoded and was wondering if there's a simple field calc formula to do this?

For example looking to take 123 Main St-AABB and calculate 123 Main St into a new field removing the city code AABB.

I have over a thousand addresses so going through deleting by hand is not an option.

Thanks

Re: Truncate Address in String Field

Anonymous User — Sun, 12 Dec 2021 02:24:00 GMT

If every record has the city code after the address separated by a dash, this can be done very easily with the field calculator. Set the parser to Python and put in this expression:

!field_name!.split("-")[0]

This will return everything before the dash, in your case "123 Main St"

Re: Truncate Address in String Field

StevenSmith1 — Wed, 24 Oct 2012 14:29:40 GMT

Thank you!

I was trying that but without the [0] at the end and it wasn't working.

I did end of getting the same result from using a combination of the InStr() to find location of "-" then Left ([fieldname], [InStr] -1) but this is one less step and faster.

Thank you again for all your help!