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

Need help with field calculator.

EGardner7

I am trying to use field calculator to move numbers to the front of a value. For example, Apple Dr. 245 to 245 Apple Dr. I have tried a bunch of different python scripts that are AI generated but I can't get it to work. Does anyone know why I could be having issues with this? Here is one script I tried for example:

def move_numbers_to_front(value):
words = value.split()
if len(words) > 1 and words[-1].isnumeric():
return f"{words[-1]} {' '.join(words[:-1])}"
return value

# Usage: move_numbers_to_front(!CableName!)

Encontre mais publicações marcadas com

Accepted answers

All comments

JoshuaBixby

Comments like "that didn't work" aren't helpful. If there was an error, what exactly was the error, and provide a traceback if one exists. If there was no error but the results are unexpected, state what you expected and what you got.

danretired

did it work? or were there other issues?

danretired

perhaps

a = None
def move_numbers_to_front(value):
    if value is None:
        return
    words = value.split()
    if len(words) > 1 and words[-1].isnumeric():
        return f"{words[-1]} {' '.join(words[:-1])}"
    return value
    

print(move_numbers_to_front(a))
None

EGardner7

Yes there are null values in the field. How do I get it to ignore those? The error message is: There was a failure during processing, check the Geoprocessing Results window for details.

danretired

Then you might want to provide the error message. Perhaps, you have some null values in the field or other issues with the contents of the field

EGardner7

Unfortunately that didn't work. Thank you though!

danretired

indentation perhaps

a = "Apple Dr. 245"

def move_numbers_to_front(value):
    words = value.split()
    if len(words) > 1 and words[-1].isnumeric():
        return f"{words[-1]} {' '.join(words[:-1])}"
    return value
    

move_numbers_to_front(a)
'245 Apple Dr.'

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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