I've got a number of different labeling scripts I use and they all at least contain one NAME type field I display. On the rare occasion, I have names that contain the "&" (such as "Rough & Ready"). I know the ampersand is a special character and when I use it in my script it starts displaying the other fileds parameters in the output text. Here is an example of one of my simple labeling codes in Python: def FindLabel([Name_1],[Width_1]): str_list = [] if [Name_1] not in (None, " "," ", "", "0"): str_list.append([Name_1]) if [Width_1] not in (None, " "," ", "", "0", " ","Varies"): Width_1_str = ' Width = {}\' '.format(" " + [Width_1] + " ") str_list.append(Width_1_str) label_str = '\n'.join(str_list) return(label_str) I have found an example using VB and somehow incorporating "&","&" into the script, but I have played around with adding variations of that in my code, but I can't seem to get it to work without errors. Any ideas how to simply allow & into my Name_1 field in this example? Thanks

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

Labeling using ampersand (&) symbol in text via Python

PeteJordan

I've got a number of different labeling scripts I use and they all at least contain one NAME type field I display. On the rare occasion, I have names that contain the "&" (such as "Rough & Ready").

I know the ampersand is a special character and when I use it in my script it starts displaying the other fileds parameters in the output text.

Here is an example of one of my simple labeling codes in Python:

def FindLabel([Name_1],[Width_1]):

str_list = []
if [Name_1] not in (None, "<NULL>","<Null>", "", "0"):
str_list.append([Name_1])

if [Width_1] not in (None, "<NULL>","<Null>", "", "0", " ","Varies"):
Width_1_str = '<ITA>Width = {}\'</ITA>'.format("<ITA>" + [Width_1] + "</ITA>")
str_list.append(Width_1_str)

label_str = '\n'.join(str_list)
return(label_str)

I have found an example using VB and somehow incorporating "&","&" into the script, but I have played around with adding variations of that in my code, but I can't seem to get it to work without errors.

Any ideas how to simply allow & into my Name_1 field in this example?

Thanks

Vind meer berichten getagd met

Accepted answers

rzufelt

Whoops, left a relic append in there. Try the above code now that I have deleted line 28 (str_list.append(name_str)).

All comments

PeteJordan

Yes, it now seems to work. I've just made a few adjustments to only bold the NAME if needed and never the other ones and it works as I originally wanted it.

Thanks for that tutorial and guess I put your mind to work a bit too...

rzufelt

Whoops, left a relic append in there. Try the above code now that I have deleted line 28 (str_list.append(name_str)).

PeteJordan

Well that seemed to solve that issue, but creates a new one now.

I can often have just the WIDTH supplied without a NAME. This code won't display it if there is no NAME given.

Also, if I add in a Route and not ALT_NAME, it duplicates the NAME field.

This is one interesting things you're trying to solve here ha...

rzufelt

Thank for the input on Italics. Turns out, my Pro uses Tahoma font by default and apperantly the <ITA> tag doesn't work with it. I changed to Arial and is working.

As far as the failing with & and only NAME, that is because there is no text tag in play when that is the only populated field so the & replacement isn't needed and will show the & in this case.

Easy fix, I just added an UN-bold <_BOL> to the name and Route string. That way, no matter what, at least one text formatting tag will be used, regardless of the number of populated fields.

This seems to do what you are after (I hope anyway )

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):

  NAME1 = str([NAME]).strip()           # assign variable to string with whitespace stripped
  ALT_NAME1 = str([ALT_NAME]).strip()   # assign variable to string with whitespace stripped
  ROUTE1 = str([ROUTE]).strip()         # assign variable to string with whitespace stripped
  WIDTH1 = str([WIDTH]).strip()          # assign variable to string with whitespace stripped
            
  str_list = []
  if [NAME]:                                    #Make sure is not empty since or can append 'None' to label
     if '&' in NAME1:
            NAME1=NAME1.replace("&","&amp;")
            
     if NAME1 not in ("<NULL>", "", "0"):        # since already string, test if in(values)
      name_str = f"<_BOL>{NAME1}</_BOL>"
      str_list.append(name_str)                    # append to list if not in the filter list

  if [ALT_NAME]:
     if '&' in ALT_NAME1:
            ALT_NAME1=ALT_NAME1.replace("&","&amp;")
            
     if ALT_NAME1 not in ("<NULL>", "", "0"):
       altname_str = f"<CLR red = '255'><ITA><FNT size = '6'>({ALT_NAME1})</FNT></ITA></CLR>"       # I changed to f'strings as easier to visualize than .format
       str_list.append(altname_str)    

  if [ROUTE]:
     if ROUTE1.upper() not in ("<NULL>", "", "0", "VARIES"):  # Cast compare variable to upper case to test for "VARIES"
       
       route_str = f"<_BOL>RT# {ROUTE1}</_BOL>"                                 # does not sound like you have much control over data
       str_list.append(route_str)                                  # so casting to upper case will catch other spellings/Case
    
  if [WIDTH]:
     if WIDTH1.upper() not in ("<NULL>", "", "0", "VARIES"):
       width_str = f"<ITA>Width = {WIDTH1}'</ITA>"
       str_list.append(width_str)    

  label_str = '\n'.join(str_list)
  return(label_str)

PeteJordan

Very odd. So I have tried your code and I get it to work, all except when there is only the NAME being displayed. Then it fails with the '&' and prints out the following:

"TEST & TEST" will show up as "TEST &amp: TRUE"

Now if I add an ALT_NAME with or without the '&' it displays both perfectly fine. Or if I add a ROUTE or WIDTH (other than what is in the exclusion) it works perfectly fine. So just the NAME with the '&' fails. This is getting pretty close to the fix though.

On another note, being on 3.0.3 myself. I did try with the <ITA> just to see if I get the same issues you did, and I am getting it working for me the exact way you used <BOL>. So odd you aren't getting that working like I am...

rzufelt

If you use text formatting tags anywhere in the labelstring, you need to put the replace function back in there to replace any '&' with & as below:

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):

  NAME1 = str([NAME]).strip()           # assign variable to string with whitespace stripped
  ALT_NAME1 = str([ALT_NAME]).strip()   # assign variable to string with whitespace stripped
  ROUTE1 = str([ROUTE]).strip()         # assign variable to string with whitespace stripped
  WIDTH1 = str([WIDTH]).strip()          # assign variable to string with whitespace stripped
            
  str_list = []
  if [NAME]:                                    #Make sure is not empty since or can append 'None' to label
     if '&' in NAME1:
            NAME1=NAME1.replace("&","&amp;")
            
     if NAME1 not in ("<NULL>", "", "0"):        # since already string, test if in(values)
      str_list.append(NAME1)                    # append to list if not in the filter list

  if [ALT_NAME]:
     if '&' in ALT_NAME1:
            ALT_NAME1=ALT_NAME1.replace("&","&amp;")
            
     if ALT_NAME1 not in ("<NULL>", "", "0"):
       altname_str = f"<CLR red = '255'><BOL><FNT name = 'Arial' style = 'Italic' size = '10'>({ALT_NAME1})</FNT></BOL></CLR>"       # I changed to f'strings as easier to visualize than .format
       str_list.append(altname_str)    

  if [ROUTE]:
     if ROUTE1.upper() not in ("<NULL>", "", "0", "VARIES"):  # Cast compare variable to upper case to test for "VARIES"
       route_str = f'RT# {ROUTE1}'                                 # does not sound like you have much control over data
       str_list.append(route_str)                                  # so casting to upper case will catch other spellings/Case
    
  if [WIDTH]:
     if WIDTH1.upper() not in ("<NULL>", "", "0", "VARIES"):
       width_str = f"<UND><BOL>Width = {WIDTH1}'</BOL></UND>"
       str_list.append(width_str)    

  label_str = '\n'.join(str_list)
  return(label_str)

This example shows changing font size, color, and making bold. the <ITA> tag, even though Pro's documentation says it works, DOES NOT WORK in either of my versions of Pro (2.9.3 or 3.0.3). However, if you look at line 21, I call out the font as Arial Italic so it displays as such.

Maybe you could contact tech support and see if there is some trick to getting the <ITA> tag to work, but suspect it is a bug. Otherwise, if you want italics, you will need to find a font that lets you declare it as above.

PeteJordan

Yes that works the same with the code I just posted earlier and allows the use of the "&". The issue is that it won't allow me to work with Itallics or font changes and that was the issue. I can get away using the code I had, or the one you posted just fine, but I won't have the ability to work with that functionality.

Again, it's more just visually appeasing, and not something I really need, but it would be nice to see if it could work with that sort of thing.

Here's the example of what I added to your code for just the Width (note I had to rename your WIDTH1 to another name as some data comes in with a Width1 as the name, and searching replacing doesn't work as well like that.) so I just renamed it to WDTH_TMP

	if WDTH_TMP:
        if str(WDTH_TMP).strip() not in (None,"<NULL>","<Null>","","0",0):
            width_str = "<ITA>Width = {}'</ITA>".format(str(WDTH_TMP))
            str_list.append(width_str)

Here's the full code using your example and the itallics and font size changes where having a "&" in the name, still causes that issue displaying the code for itallics, etc as the original issue had. Removing those of course works fine, but I don't get this added visual possibilities is all...

(I will be out on vacation for a week so after tomorrow, I'll repond and check out any other suggestions next week.)

Font.jpg

rzufelt

OK, since you don't seem to have control of text vs numeric data, lets cast everything to text first.

while at it, might as well .strip() any spaces on either end of the text string.

Now we have varibles (with"1" appended to the end) that are strings with no extra white spaces.

I also changed from variable.format() to f'{variable}' format as it is easier to visualize and keep track of.

Since you don't have control over the data given, lets compare ROUTE1 and WIDTH1 upper case. This way, doesn't matter if the field says "Varies", "varies", "VARIES", etc. will be filtered out.

Now, as far as null values, difficult figureing a way to query them out when then can be text or numeric without actually putting "None" in the label field.

The following seems to work regardless of the input format (text vs number):

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):

  NAME1 = str([NAME]).strip()           # assign variable to string with whitespace stripped
  ALT_NAME1 = str([ALT_NAME]).strip()   # assign variable to string with whitespace stripped
  ROUTE1 = str([ROUTE]).strip()         # assign variable to string with whitespace stripped
  WIDTH1 = str([WIDTH]).strip()          # assign variable to string with whitespace stripped
  
  
  str_list = []
  if [NAME]:                                    #Make sure is not empty or can append 'None' to label
    if NAME1 not in ("<NULL>", "", "0"):        # since already string, test if in(values)
      str_list.append(NAME1)                    # append to list if not in the filter list

  if [ALT_NAME]:
     if ALT_NAME1 not in ("<NULL>", "", "0"):
       altname_str = f'({ALT_NAME1})'            # I changed to f'strings as easier to visualize than .format
       str_list.append(altname_str)    

  if [ROUTE]:
     if ROUTE1.upper() not in ("<NULL>", "", "0", "VARIES"):  # Cast compare variable to upper case to test for "VARIES"
       route_str = f'RT# {ROUTE1}'                                 # does not sound like you have much control over data
       str_list.append(route_str)                                  # so casting to upper case will catch other spellings/Case
    
  if [WIDTH]:
     if WIDTH1.upper() not in ("<NULL>", "", "0", "VARIES"):
       width_str = f'Width = {WIDTH1}'
       str_list.append(width_str)    

  label_str = '\n'.join(str_list)
  return(label_str)

PeteJordan

Well for the Width the original code had

    if WDTH_TMP:
        if str(WDTH_TMP).strip() not in ("<NULL>","<Null>","0","Varies"):
            width_str = "<ITA>Width = {}'</ITA>".format(str(WDTH_TMP))
            str_list.append(width_str)

as I need to exclude 0 if it was a numeric field, or exclude text values that show up as "<NULL>, "0", "<Null>" and "Varies". These have been populated in the Width field if the Width was a text field and ones with those values, I didn't want to display at all as a lable if they contained those values...

rzufelt

Can you give example : " I can't exclude some of the text variables that might show up if that field is a Text rather than Numeric." I'm not sure what you are getting at here.

Normally one standardizes the schema (text in text fields, numbers in numeric) to avoid this type of issue.

PeteJordan

Though the problem now is I can't exclude some of the text variables that might show up if that field is a Text rather than Numeric. I have gotten this version of the code to work without any issues. The only problem of course is the labeling features such as font size and Itallics aren't included, but I can deal with that as the "&' in the NAME or ALT_NAME is more important.

Thanks for your help though on this again...

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):

  str_list = []
  if [NAME] not in (None, "<NULL>", "", "0"):
    str_list.append([NAME])

  if [ALT_NAME] not in (None,"<NULL>", "", "0"):
    altname_str = '({})'.format([ALT_NAME])
    str_list.append(altname_str)    

  if [ROUTE] not in (None,"<NULL>", "", "0"):
    route_str = 'RT# {}'.format([ROUTE])
    str_list.append(route_str)  
    
  if [WIDTH] not in (None, "<NULL>", "", "0"):
    width_str = 'Width = {}'.format([WIDTH])
    str_list.append(width_str)    

  label_str = '\n'.join(str_list)
  return(label_str)

rzufelt

Apperantly, python evaluates a zero as emtpy, but not None/Null.

the If WDTH_TMP: comparison will evaluate to false if NAME1 is numeric and = 0 so is bailing out before the next comparison.

If you change it to 'is not None', it shouldn't have this issue:

    if NAME1 is not None::                                        # checks to see if value or Null
        if '&' in NAME1:                             # as string value can print as None, but doesn't work with "not in"
            NAME1=NAME1.replace("&","&amp;")

        if str(NAME1).strip not in ("<NULL>","<Null>","0"):   
            str_list.append(NAME1)

PeteJordan

RhettZufelt , I did run into an issue though. As I mentioned before, the WIDTH can actually be a string in some cases or numeric in other cases.

So right now this code works if the WIDTH is a String, but it fails if it's numeric and WIDTH=0. So I've tried to add in just a 0 into the code, but it doesn't seem to ignore that. I've also tried to use the None as well without success.

(Note I had to change the name of the Width_1 to WDTH_TMP to make it easier.

Here's what I'm trying without success if the value is 0 and WIDTH is actually a numeric field.

  if str(WDTH_TMP).strip() not in (None,"<NULL>","<Null>","0",0):

PeteJordan

Thanks so much, and I actually used the code block in the past and just forgot how to use it, so thanks for that refresher for my future questions on the forum.

I liked how you explained everything and that made it much easier to understand why you changed what you did. Now I can update my document with this and make it a lot more inclusive to the types of naming conventions we get.

With the Width, yes we can get just numeric values or such things like "8FT" or "Varies", so I always have to treat that as a text field (I forgot to include the "varies" back into the code, but that's an easy fix).

Thanks so much for this help...

rzufelt

For future pasting of code, look at this post, makes it a lot easier to visualize as well as copy/paste.

As far as it not working for ALT_NAME, you are substituting [ALT_NAME] in with the .format, but it is ALT_NAME1 that you did the replace on. Simple fix.

Also, you said could be text, could be numeric. Comparing strings with in/not in and None doesn't neccesarily produce consistent results. I modified this a little to first, see if there is a value in the variable (not Null), then, compare the str(variable) with the not in staments. Seems to produce the results we're after.

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):
    str_list = []

    NAME1=[NAME]
    ALT_NAME1=[ALT_NAME]
    ROUTE1=[ROUTE]
    WIDTH1=[WIDTH]
    if NAME1:                                        # checks to see if value or Null
        if '&' in NAME1:                             # as string value can print as None, but doesn't work with "not in"
            NAME1=NAME1.replace("&","&amp;")

        if str(NAME1).strip not in ("<NULL>","<Null>","0"):   
            str_list.append(NAME1)
    if ALT_NAME1:
        if '&' in ALT_NAME1:
            ALT_NAME1=ALT_NAME1.replace("&","&amp;")
        if str(ALT_NAME1).strip() not in ("<NULL>","0"):
            altname_str = "<BOL><FNT size = '6'>({})</FNT></BOL>".format(str(ALT_NAME1))
            str_list.append(altname_str)
    if ROUTE1:
        if str(ROUTE1).strip not in ("<NULL>", "0"):
            route_str = "RT#: {}".format(ROUTE1)
            str_list.append(route_str)
    if WIDTH1:
        if str(WIDTH1).strip() not in ("<NULL>","<Null>","0"):
            width_str = "<BOL>Width = {}'</BOL>".format(str(WIDTH1))
            str_list.append(width_str)

    label_str = '\n'.join(str_list)
    return(label_str)

Of course, since my version of Pro doesn't honor the ITA tags, I used BOL to see that it is working.

You will need to replace them if you want italics instead (if it works in your version).

PeteJordan

Ok I got the Name part working with the & which is great and thank you for that.

In the larger code (which is different than the example I showed you),
I am trying to apply that to 2 fields out of 4. In this example NAME and ALT_NAME.

I run into issues when trying to do it for a 2nd field.

Here's the code that I can't seem to get working. One issue is that you stated the <ITA> and such may not be supported in this fashion, 2nd I can't get this code to work at all regardless of where I place the ALT_NAME1 if statements for the &:

def FindLabel([NAME],[ALT_NAME],[ROUTE],[WIDTH]):
str_list = []

NAME1=[NAME]
ALT_NAME1=[ALT_NAME]
ROUTE1=[ROUTE]
WIDTH1=[WIDTH]
if '&' in NAME1:
NAME1=NAME1.replace("&","&")

if NAME1 not in (None, "<NULL>","<Null>", "", "0"):
str_list.append(NAME1)

if '&' in ALT_NAME1:
ALT_NAME1=ALT_NAME1.replace("&","&")
if ALT_NAME1 not in (None,"<NULL>", "", "0"):
altname_str = "<ITA><FNT size = '6'>({})</FNT></ITA>".format(str([ALT_NAME]))
str_list.append(altname_str)

if ROUTE1 not in (None,"<NULL>", "", "0"):
route_str = "RT#: {}".format([ROUTE])
str_list.append(route_str)

if WIDTH1 not in (None, "<NULL>","<Null>", "", "0", " "):
width_str = "<ITA>Width = {}'</ITA>".format(str([WIDTH]))
str_list.append(width_str)

label_str = '\n'.join(str_list)
return(label_str)

rzufelt

It appears as if 2.9.3 won't honor the <ITA> tags, so was getting nowhere. However, I decided to replace the italics tag with <BOL> tags for testing.

However, according to this page, "The ampersand (&) and angle bracket (<) are special characters and are not valid in your text if formatting tags are used. Use the equivalent character codes & and < instead.

Annotation

Instead of <ITA>John & Paul</ITA>, use:

<ITA>John & Paul</ITA>

So, will have to look for the special character, and if there, replace with &.

With lines 5 and 6 commented out:

Then, uncommented:

Hope this helps figure out what is going on.

PeteJordan

So that at least shortened the script a bit by removing like you said the extra itallics from the WIDTH part, but I still have the same issue with the NAME and using & in the name as in my last screen shot...

rzufelt

Sorry, my mistake on that error. I have edited that post, guess still stuck on the ArcMap way of having to actually call that function in the label editor.

PeteJordan

Well first off, the WIDTH is not always a numeric field, it can sometimes be a text field depending on who gives us the data. This is also one of the simple labeling functions I do, there could be a number of other fields that also get displayed. I just used these two NAME and WIDTH as an easy example.

The code you suggested returned an error:

Here's an example of what I am experiencing

This is how my names should look and in this case I substituted the '&' with'and'. It also has the width field shown as well in itallics.

Example 2 (amp_ex2.jpg) shows what I am getting if I use the '&' instead...

rzufelt

Not sure your desired output, or input for that matter, but I don't seem to have an issue with the ambersand in a string variable. You are, however, calling a lot of your "variables" lists. Python uses the !variable! to define the input variables, not [variable]. Is Width_1 a numeric or text field. If numeric, putting quotes around the zero's signify that they are text, and if width is number, will still append it if 0. Also, the .format() was duplicating the <ITA> tags as well. If that is what you were after, you will have to add that back in.

Try this code, see if it gets you closer to what you are after:

def FindLabel([Name_1],[Width_1]):

str_list = []
if [Name_1] not in (None, "<NULL>","<Null>", "", 0):
   str_list.append([Name_1])

if [Width_1] not in (None, "<NULL>","<Null>", "", 0, " ","Varies"):
   Width_1_str = '<ITA>Width = {}\'</ITA>'.format(str([Width_1]))
   str_list.append(Width_1_str)

label_str = '\n'.join(str_list)
return(label_str)

PeteJordan

Just what's shown in the code above. The actual fied is a text field though in the dataset...

AngelaSchirck

Are you passing [Name_1] as a string?

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.