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

Script to Create New Label by Deleting after a comma &amp; Splitting into 2 lines

TiaMorita

I am using the ESRI CBSA feature class, and the names are super long, for example:

Anniston-Oxford-Jacksonville, AL Metropolitan Statistical Area

I want a VBscript or python script to use as a label expression to delete all words after the comma, and then stack the label into 2 lines, for example:

Anniston-Oxford-
Jackson

Any suggestions? Thanks!

Vind meer berichten getagd met

Accepted answers

TiaMorita

 def FindLabel ( [Name] ):   Split = [Name].split(",")   Split = Split[0] #drops everything after comma   Split = Split.split("-") #splits by the hyphen   if len(Split) == 2:     expression = Split[0] + "- \n" + Split[1]      return expression   elif len(Split) == 3:     expression = Split[0] + "-" + Split[1] + "- \n" + Split[2]     return expression   else:     return Split[0] 
Likewise mine labelled all the samples. It will only work if there are 3 or less cities names in the name field.

I like yours Sol, except it splits single names in half, I think those ones would be fine on one line, but I guess its not my call.

Actually - I think this it! Looks like it works! 🙂

script result.jpg

All comments

TiaMorita

Thanks, but all that does is get rid of the comma and then stack the label. What I want to do is get rid of all the text after the comma (including the comma) and stack the label.

For example, if the name is "Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area"

I want to read something like:

Atlanta-Sandy
Springs-Rosewell

IanMurray

This may work, it will depend on how many names come before the comma.

This should drop everything after the comma, then put the first two cities on top with the 3rd city beneath, if there are only two cities hyphenated, then it will stacked them one atop another.

def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" Split[1] 
  elif len(Split) == 3:
    expression = Split[0] +"-" + Split[1] + "- \n" + Split[2]
  return expression

Make sure you use python and advanced expression.

Unfortunately I have no data to test on but hopefully this does it.

TiaMorita

Thanks for giving it a shot. Unfortunately, I get an error message: "The expression contains an error. Modify the expression and try again. Error 0 on line 0. SyntaxError: invalid syntax (<string>,line6)."

the field name I'm working with is [name].

I don't really care where the words get split up so long as it creates 2 lines (maybe so long as it gets split after the second word/name?) Also, some of the names have hyphens between each name and others not. For example:

Albany-Schenectady-Troy, NY Metropolitan Statistical Area
Virginia Beach-Norfolk-Newport News, VA-NC Metropolitan Statistical Area
Tampa-St. Petersburg-Clearwater, FL Metropolitan Statistical Area

Thanks for the help!!!

IanMurray

Whoops left off a + sign


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
  elif len(Split) == 3:
    expression = Split[0] +"-" + Split[1] + "- \n" + Split[2]
  return expression

GIve that a shot.

TiaMorita

Still not working 😞
See attached error msg

error msg.jpg

IanMurray

lol this would be alot easier if I had the dataset and could debug myself. I tend to make a few errors when writing scripts

I needed to put the return expression within the if/elif statement I believe


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
    return expression
  elif len(Split) == 3:
    expression = Split[0] +"-" + Split[1] + "- \n" + Split[2]
    return expression

TiaMorita

The result looks like this...

script result.jpg

TiaMorita

I was looking for a script that deletes all the info after the comma, and then splits the City name into 2 lines.

IanMurray


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
    return expression
  elif len(Split) == 3:
    expression = Split[0] +"-" + Split[1] + "- \n" + Split[2]
    return expression

TiaMorita

Whoops left off a + sign


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
  elif len(Split) == 3:
    expression = Split[0] +"-" + Split[1] + "- \n" + Split[2]
  return expression

GIve that a shot.

Hi there - the results comes out empty 😞

TiaMorita

Here is some sample data to help out. Both of you are close, so hopefully this will help!

CBSA_sample.zip

IanMurray

from your reply, you didn't use my most recent script, or at least you didn't post it back.


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
    return expression
  elif len(Split) == 3:
    expression = Split[0] + "-" + Split[1] + "- \n" + Split[2]
    return expression

Edit: Also, the attribute table for that file was empty.

Edit Again: NVM, I didn't unzip properly

IanMurray


def FindLabel ( [Name] ):
  Split = [Name].split(",")
  Split = Split[0] #drops everything after comma
  Split = Split.split("-") #splits by the hyphen
  if len(Split) == 2:
    expression = Split[0] + "- \n" + Split[1] 
    return expression
  elif len(Split) == 3:
    expression = Split[0] + "-" + Split[1] + "- \n" + Split[2]
    return expression
  else:
    return Split[0]

Likewise mine labelled all the samples. It will only work if there are 3 or less cities names in the name field.

I like yours Sol, except it splits single names in half, I think those ones would be fine on one line, but I guess its not my call.

[ATTACH=CONFIG]33885[/ATTACH]

Sample.png

TiaMorita

It worked for me with the sample data you sent.

Function FindLabel ([NAME])
pos = instr([NAME],"," )
lab =  Left([NAME], pos - 1)
leng = len(lab)
half = Int(leng/2)
first = left(lab,half)
digits = leng-half
nex = right(lab,digits)
 FindLabel = first & vbnewline & nex
End Function

Thanks, Sol

No - this was the result I got (see attached).

script result.jpg

TiaMorita

 def FindLabel ( [Name] ):   Split = [Name].split(",")   Split = Split[0] #drops everything after comma   Split = Split.split("-") #splits by the hyphen   if len(Split) == 2:     expression = Split[0] + "- \n" + Split[1]      return expression   elif len(Split) == 3:     expression = Split[0] + "-" + Split[1] + "- \n" + Split[2]     return expression   else:     return Split[0] 
Likewise mine labelled all the samples. It will only work if there are 3 or less cities names in the name field.

I like yours Sol, except it splits single names in half, I think those ones would be fine on one line, but I guess its not my call.

Actually - I think this it! Looks like it works! 🙂

script result.jpg

IanMurray

Yeah, I agree splitting the text in half like that is not really nice, but the OP said that it didn't matter so I didn't make it more complicated. Plus I'm racing against you to figure it out. lol 🙂 Plus I have to leave work now...

Haha, pretty much the same here. From the two examples that were given I figured she wanted them to be split by the city names so thats what I went for. Nothing wrong with yours, just a stylistic difference 😉

Edit: Dang, she marked her quote of my response as answer, no answer provided for me 😞

😛

IanMurray

Yours worked, it just wasn't quite stylistically what they wanted I suppose.

Go home and have a good night!

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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