topic Arcade Script Error in Data Management Questions

Arcade Script Error

RomanFox — Mon, 01 Jul 2024 19:13:09 GMT

Hello,

I am trying to set an Attribute Rule in ArcPro. I am receiving "Invalid expression. Error on line 1. Field not found Cleanliness_Rating.

I have a field (Cleanliness_Rating) with a text value (from a Domain) of 1-xyzxyzx... , and I want it to slice the first value (1) and return it as a number.

I have test data in the fields. Am I missing something that will allow the field to be found?

Thanks,

Re: Arcade Script Error

jcarlson — Mon, 01 Jul 2024 20:16:58 GMT

Try using bracket notation, $feature['Cleanliness_Rating']. Dot notation works most of the time, but bracket notation works all the time.

Also, Arcade isn't Python, so it's really not going to work that way. What you want is the text function Mid for getting text out from the string, or Left to get the first character. Try this instead:

Left($feature['Cleanliness_Rating'], 1)

Re: Arcade Script Error

doyle2jm — Mon, 01 Jul 2024 20:21:36 GMT

Two quick thoughts:

Arcade might not like a space between Text(), if there is one.
you could try using Left() instead of slice to see if that would give you the expected result. I am not familiar with 'slice' but also Split() may give you the answer you are looking for too. People tend to stay away from left() because it's not as precise as Split() though. Example w/ left():
```
var firstchar = $feature.cleanliness_rating;
var extractsubstring = Left(firstchar,1);
var result = Number(extractsubstring);
return result;
```

Re: Arcade Script Error

simoxu — Tue, 02 Jul 2024 06:32:06 GMT

You mentioned you are using domain for that field:

"I have a field (Cleanliness_Rating) with a text value (from a Domain) of 1-xyzxyzx..."

To get the descriptive value, you should use DomainName($feature, 'Cleanliness_Rating'), please give it a try.

https://developers.arcgis.com/arcade/function-reference/feature_functions/#domainname

Re: Arcade Script Error

RomanFox — Tue, 02 Jul 2024 14:32:35 GMT

This makes sense. I have tried two different configurations of the above idea:

var firstChar = Left($feature['Cleanliness_rating'],1)
var result= Number(firstChar);
result

This results in "Invalid expression. Error on line1. Object not found cleanliness_rating

var firstChar = Left($feature['Cleanliness_rating'],1)
var result= Number(firstChar);
result

This results in "Invalid Expression. No features found."

I also tried the below idea with this:

var firstChar = Cleanliness_Rating($feature,[Cleanliness_rating],1)
var result= Number(firstChar);
result

The results in "Invalid expression. Error on line 1. Unknown function"

Re: Arcade Script Error

RomanFox — Tue, 02 Jul 2024 14:35:18 GMT

There wasn't a space after "Text"

The above expression results in the message "Invalid Expression. No features found"

Re: Arcade Script Error

RomanFox — Tue, 02 Jul 2024 14:41:06 GMT

I gave that a try:

Cleanliness_Rating($feature. 'cleanliness_rating')

This results in " Invalid expression. Error on line 1. Identifier expected"

Re: Arcade Script Error

jcarlson — Tue, 02 Jul 2024 14:46:08 GMT

Yeah, that third option won't work unless you define the function first.

Those errors on the first two seem strange. Are you positive you're typing the field name correctly?

Let's do some debugging. Can you add some Console statements to the top of your expression and see what it spits out?

Console($feature) for (var attribute in $feature) { Console(attribute, $feature[attribute]) } Console($feature['Cleanliness_rating'])

Re: Arcade Script Error

RomanFox — Tue, 02 Jul 2024 15:45:26 GMT

Alright, my test data was corrupted. I reloaded the data and we are good to go. The below expression is valid and functioning:

var firstChar = Left($feature['Cleanliness_rating'],1)
var result= Number(firstChar);
result

Thank you everyone for the help. I learn something new everyday.