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

Modelbuilder: Why is <u"> being added to my calculation values?

RandyMcGregor_BMcD

I have a simple calculation in a Calculate Field tool in modelbuilder. %Field Name% is a variable that references an actual field that is in the attribute table.

This is what the results look like:

I have been using inline variable substitution regularly and have never seen anything like this. If I double-click the field from the drop-down, instead of using '!%Field Name%!', it works as desired.

Does anyone know what is going on here and how to correct it?

Thank you,

Randy McGregor

Trouver plus de publications taguées avec

Desktop

Accepted answers

All comments

RandyMcGregor_BMcD

I did have luck with !'%field name variable%'! though. Keeping the exclamation marks outside the quote marks worked. I think your advice will help with Arcade expressions. I'll give it a try.

RandyMcGregor_BMcD

Thank you very much for that explanation. Very interesting.

VenkataKondepati

This is a ModelBuilder evaluation-order issue, not user error.

Inline substitution (%Field Name%) is resolved before Calculate Field runs, but the expression itself is parsed later. The result is that the substituted value is treated as literal text, not a field reference — which is why you see the field name written into the row.

Don’t use inline substitution inside Calculate Field expressions. Always use the actual field token (!FieldName!) or resolve the expression first (e.g., with Calculate Value) and pass it in.

The %variables% and Calculate Field don’t play nicely together due to timing — explicit field tokens are the safe path.

RandyMcGregor_BMcD

Oookay, so I went back to python and put the "!" marks outside of the quote marks and that works. There's some trick to getting arcade to recognize that you are asking for the value within the field, rather than the field's name, but I don't know what it is.

RandyMcGregor_BMcD

That populated the field with the name of the field. I tried Arcade and had the same effect. I have no memory of ever having to clarify that I want the contents of the field, rather than it's name to populate reccords. I'm either having an end-of-year brain freeze, or something strange is going on. 'ParishXed3' is the name of the field.

If I select the field from the drop-down, it works fine:

RandyMcGregor_BMcD

Thanks for the suggestion. I'll give it a try.

CodyPatterson

Hey @RandyMcGregor_BMcD

Would it be possible to test the function without the exclamation points? I remember having an issue where the exclamation points were causing an issue, but I'm unfortunately no longer able to test and can only give suggestions!

Cody

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.