topic Re: Label Expression in Addressing Questions

Label Expression

EmmanuelJohn1 — Mon, 31 Jul 2017 20:27:58 GMT

Hello,

does anyone know of an expression that can help me make a label of everything before the first space within a field??

Example:

Home numbers of an address field.

Re: Label Expression

IanMurray — Sun, 12 Dec 2021 10:09:59 GMT

Using Python Parser.

def FindLabel ( [fieldname]):
  return [fieldname].split(" ")[0]‍‍‍‍

I'm assuming that the field in question is a text field. This splits a text string by a space character(.split(" ") and returns the first portion of that string(actually splits the whole string into a list of strings and returns the first item of that list hence the [0])

Re: Label Expression

EmmanuelJohn1 — Tue, 01 Aug 2017 14:18:02 GMT

Re: Label Expression

EmmanuelJohn1 — Tue, 01 Aug 2017 14:21:49 GMT

Thank You Ian for introducing Split concept, I was able to use this in the field calculator with python parser

!fieldname!.split(" ")[0]

Re: Label Expression

AdrianWelsh — Tue, 01 Aug 2017 14:41:01 GMT

Emmanuel,

Please mark Ian's response as Correct to close out this thread.

Re: Label Expression

kathyhardinwalker — Wed, 16 May 2018 17:01:30 GMT

This is not working for us in ArcGIS Pro. We are also trying to return everything before the first space (or drop everything after the first space). I attached a picture of what the Invalid Expression response was. Thank you in advance for saving the day

Kathy

Re: Label Expression

JoeBorgione — Wed, 16 May 2018 17:08:53 GMT

kathy walker‌: You may need to put exclamations around the [ADDRESS] in line 1:

Re: Label Expression

kathyhardinwalker — Wed, 16 May 2018 20:12:41 GMT

Thank you Joe. We finally got something that works:

def FindLabel ( [Location] 😞
    if [Location] == None:
         return "No Address"
    else:
         x = [Location]
         x1 = x.split(" ")
         return x1[0]

Re: Label Expression

JoeBorgione — Wed, 16 May 2018 21:24:36 GMT

kathy walker - I just gave the original expression a go and it worked for me. It appears that when using the python parsing tool ArcGIS Pro understands that exclamations are implied. (Like the use of quotes as well...) I thought your problem might have been None values, but my data has them too. Not sure what's up there....

Re: Label Expression

kathyhardinwalker — Wed, 16 May 2018 21:30:25 GMT

One problem we discovered, the field we were using was indexed, it had an asterisk (Address*) in the header. As soon as we switched to a field that was not indexed we started getting somewhere.