I have been trying to do a field calculation in ArcMap 10.0 sp5 and PYTHON_9.3 expression type, with not much success. The field I am trying to calculate is a Text field with a length of 50, even though the data in that field "should" never have a length longer than 12 (it's not my data), it's just the way that field was created. The error: Start Time: Thu Nov 01 10:13:08 2012 ERROR 000539: : EOL while scanning string literal ( , line 1) Failed to execute (Calculate Field). Failed at Thu Nov 01 10:18:15 2012 (Elapsed Time: 5 minutes 7 seconds) There are some feature attribute values in the field that have some kind of padding applied to them which is causing this error - I believe. .strip() is not removing the whitespace, as the script will process about 80% of the records before it hits the one record causing the problem. Can anyone tell what I'm missing? model.jpg

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 Calculation: ERROR 000539

LeoDonahue

I have been trying to do a field calculation in ArcMap 10.0 sp5 and PYTHON_9.3 expression type, with not much success.

The field I am trying to calculate is a Text field with a length of 50, even though the data in that field "should" never have a length longer than 12 (it's not my data), it's just the way that field was created.

The error:

Start Time: Thu Nov 01 10:13:08 2012
ERROR 000539: <type 'exceptions.SyntaxError'>: EOL while scanning string literal (<expression>, line 1)
Failed to execute (Calculate Field).
Failed at Thu Nov 01 10:18:15 2012 (Elapsed Time: 5 minutes 7 seconds)

There are some feature attribute values in the field that have some kind of padding applied to them which is causing this error - I believe.

.strip() is not removing the whitespace, as the script will process about 80% of the records before it hits the one record causing the problem.

Can anyone tell what I'm missing?

model.jpg

Trouver plus de publications taguées avec

Accepted answers

All comments

klem

Hi Leo,

you are probably right, there is "new line" (\n) or tab (\t) character, so first you should clean this field or add
parcel = parcel.replace("\n","")
parcel = parcel.replace("\t","")
...
lines to your code.

LeoDonahue

If I start an edit session and put my cursor in the parcel record ending in 062, then use the arrow keys to arrow right, the value disappears. I'm guessing this is why I should be trying to replace the \n values?

BruceBacia

That's really weird. I see no clear difference between records 959777 and 959778 that would cause one to calculate and the other to error out. I would highly recommend the try and except blocks. The calculation won't ever completely error out...if it can't perform the operation, it will default to 'Unable to calculate'. This will allow you to analyze what is different about those records that aren't calculated.

def setAPN2(parcel):
    try:
        parcel = parcel.strip()
        strValue = parcel[0:3] + '-' + parcel[3:5] + '-'  
        if len(parcel) <= 8:
            strValue += parcel[5:]
        else:
            strValue += parcel[5:8] + '-' + parcel[8:]
    except:
        strValue = 'Unable to calculate'
    return strValue

LeoDonahue

Bruce, Krzysztof,

Thanks for the tips.

I don't visually see a \n character in any of the values. Does that mean it might be there anyway?

I am still getting this error when I run the following code.

[ATTACH=CONFIG]19106[/ATTACH]

python_code.jpg

parcels_sample_where_it_stops.jpg

BruceBacia

Actually.....looking at the code and the error, i'm pretty sure what is wrong. It is trying to strip the field name argument itself, which isn't a string. That's why you're getting the scanning string literal error. Try the solution below:

Expression

setAPN2(str(!PG_APN!))

Then alter the function:

def setAPN2(parcel):
    if parcel != 'None':
        try:
            parcel = parcel.strip()
            strValue = parcel[0:3] + '-' + parcel[3:5] + '-'
            if len(parcel) <= 8:
                strValue += parcel[-3:]
            else:
                strValue += parcel[5:8] + '-' + parcel[-1:]
        except:
            strValue = 'Error - unable to calculate'
        return strValue

BruceBacia

Oops...missed part of the logic for parcel strings with length > 8. Also added a calculation of error records to 'Error - Unable to calculate'

def setAPN2(parcel):
    if parcel != 'None':
        try:
            strValue = parcel[0:3] + '-' + parcel[3:5] + '-'
            if len(parcel) <= 8:
                strValue += parcel[-3:]
            else:
                strValue += parcel[5:8] + '-' + parcel[-1:]
        execept:
            strValue = 'Error - unable to calculate'
        return strValue

BruceBacia

It could be null values that are throwing it off. For 'Expression' change it to

setAPN2(str(!PG_APN!).strip())

This will convert any null values to a string representation of 'None'. Then alter your function like below Even if this isn't what is causing your specific error, this is good practice to ensure against null values breaking your code. You would then need to alter your function as below to only work on non-null values. Also, you can wrap the whole thing in try and except blocks to analyze which values aren't calculating and why. If none of the records get calculated, it's probably an error in the logic. Can you post a screenshot of some of the sample record values in the PG_APN field?

def setAPN2(parcel):
    if parcel != 'None':
        try:
            strValue = parcel[0:3] + '-' + parcel[3:5] + '-'
            if len(parcel) <= 8:
                strValue += parcel[-3:]
            else:
                strValue += parcel[-1:]
            return strValue
        execept:
            pass

klem

Check if are there any "\" characters in the string (like \n, \t). If so, replace them with "//" first.

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.