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

Convert Excel formula to Python

GISCityofPrinceAlbert

Hello, I am fairly new to Python and just started working with ArcPro. I have a solution for my problem working in an excel formula but would like to know how to get this to work in Code Block of Pro.

I have 2 fields; Location and Section. My excel formula is this:

=IF((LEFT(A2,3)="RMS"),"",REPLACE(A2,1,1,B2))

A2 is location and B2 is Section. So if the 1st 3 characters of the location = RMS then nothing else replace the first character with Section

The data looks like this

Location	Section	Formula
B - 18 - F - 1 - N.5	A	A - 18 - F - 1 - N.5
RMS - 18 - F - 1 - N.6	RMS

I have been searching all over but just can't seem to figure it out.

Thank you.

Trouver plus de publications taguées avec

Accepted answers

GISCityofPrinceAlbert

I think I figured it out, thank you for the help.

All comments

GISCityofPrinceAlbert

I think I figured it out, thank you for the help.

GISCityofPrinceAlbert

Ideally I would like to update the location field and not create a new field. So if location starts with RMS then do nothing but if the 1st character in Location does not equal Section then update the 1st character in location to change to Section value. Hopefully that makes sense. Thank you!

danretired

def replace_(fld, val):
    """Replace a value if found"""
    if fld[:3] == val:
        return val
    else:
        return fld[:3]

python expression

replace_(!Location!, "RMS")

code block is above

However... you really don't say what you want to do it the Location field isn't really RMS ???

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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