topic Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines in ArcGIS Enterprise Portal Questions

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

TiaMorita — Fri, 16 May 2014 18:54:58 GMT

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!

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 19:52:02 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:33 GMT

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.

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 20:21:02 GMT

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!!!

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:36 GMT

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.

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 20:36:44 GMT

Still not working 😞
See attached error msg

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:39 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 20:44:40 GMT

The result looks like this...

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 20:51:34 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:41 GMT


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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Sat, 11 Dec 2021 21:58:44 GMT

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 😞

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 21:03:37 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:47 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Sat, 11 Dec 2021 21:58:50 GMT


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]

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Sat, 11 Dec 2021 21:58:53 GMT

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

TiaMorita — Fri, 16 May 2014 21:24:43 GMT

 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! 🙂

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Fri, 16 May 2014 21:26:26 GMT

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 😞

😛

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

IanMurray — Fri, 16 May 2014 21:33:23 GMT

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

Go home and have a good night!

topic Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines in ArcGIS Enterprise Portal Questions

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

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

Re: Script to Create New Label by Deleting after a comma & Splitting into 2 lines

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