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

Field Calculator Help How to pad a string with periods to fit remaining field length

JonM32

Hi Everyone,

I'm trying to create a nice road index for a map. One that looks like the screenshot below. However, I can't figure out how to create the index so that my road name listed has periods filling in the remaining space before the index cell is listed.

So far, I found some examples of python to use but nothing specific to how to enter it into the field calculator in ArcGIS Pro. The table shows my two fields, one with the street name, the other with the index cell it falls in on my map.

Any help is appreciated!

Index example.png

table example.png

Najděte více příspěvků označených jako

Accepted answers

Tonyalmeida

You probably have nulls, spaces and number and text.

try this,

def format_index(name, index, total_length=5):  # Change to your data 
    name = str(name).strip()  # String and strip whitespace
    index = str(index).strip()  # String and strip whitespace
    available_space = max(1, total_length - len(name) - len(index))
    dot_fill = '.' * available_space
    return f"{name}{dot_fill}{index}"

All comments

ClayDonaldsonSWCA

this is a perfect use case for f-strings. fstring.help: Python f-string guide

f"{!ALLROADNAM!:.<10}"
examples:
f"{'Done':.<12}" # Done.........
f"{123:.>8}" # .....123
f"{'Middle':.^10}" # ..Middle..

Tonyalmeida

try,

format_index(!Field1Cal!, !IndexCell!)

def format_index(name, index, total_length=5): #change total_length
    name = name.strip()
    index = index.strip()
    dot_fill = '.' * max(1, total_length - len(name) - len(index))
    return f"{name}{dot_fill}{index}"

JonM32

@ClayDonaldsonSWCA Below is what I'm running into with the f-strings. Likely I'm entering it incorrectly, any idea whats going on?

index error.png

JonM32

@TonyAlmeida I tried your suggestion and am running into the issue below. Any idea what is going on? I did change the first part before the code block to match my field names.

index error 2.png

Tonyalmeida

You probably have nulls, spaces and number and text.

try this,

def format_index(name, index, total_length=5):  # Change to your data 
    name = str(name).strip()  # String and strip whitespace
    index = str(index).strip()  # String and strip whitespace
    available_space = max(1, total_length - len(name) - len(index))
    dot_fill = '.' * available_space
    return f"{name}{dot_fill}{index}"

JonM32

@TonyAlmeida I'm so close! It was able to run in the field calculator - but now I'd like to get dots to even out so the index values are all aligned together. Similar to the first screenshot above. Below is what I have, is there a way to align the index values?

I really appreciate your help!

table 2.png

table 3.png

field calculator 3.png

AustinAverill

The expression is evaluating your field to include double quotes, and is therefore conflicting with your syntax. Change the code in your field calc to use single quotes instead of the double quotes will resolve the error: f'{!ALLROADNAM!:.<10}'

ChrisUnderwood

Hello @JonM32 , something like this will work in the Field Calculator without a Code Block if you prefer.

!COUNTRY!+("..............."[:(15-(len(!COUNTRY!)))])+str(!MYINT!)

JonM32

@ChrisUnderwood This worked, but the result is the same as above where I get uneven columns. The first screenshot in my initial post is my goal. I'd like to have the road names listed, and then have dots until the index cell is listed, but have them all line up together. Hopefully this makes sense!

DanPatterson

perhaps a monospaced font would have to be specified, which is probably an unlikely case for field calculations.

JonM32

Success! So, the solution is from both @TonyAlmeida and @DanPatterson

Below are screenshots of the results and field calculator expression used.

The expression allowed for me to set a number for how many dots I'd like with the remaining space in a given text field. After running it, I still had alignment issues. However, I switch to a monospaced font (Courier New) and everything aligned perfectly! I plan to use this to create the final road index I'm making for a street map.

Thank you everyone for your help!

Jon

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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