topic Not sure on functionality needed for AGOL popup expression in ArcGIS Online Questions

Not sure on functionality needed for AGOL popup expression

OliviaMancuso — Tue, 21 Jan 2025 14:55:57 GMT

Hello, I am working with a field that includes numeric values as a string that appear like this: 0820;0830;0840;0850;0860;0870A;0880;0890;1050;1060;1070;1080;1100;1110;1120;1140;1150;1160.

What I would like to do is separate each value on a new line and remove leading zero/one trailing zero in my popup. I am working with the arcade script below. So far the script is working as I get a list like the following:

But the problem I am having is that I don't know how to deal with values that also include a letter. In those rare cases, it can be any letter (always at the end), and I don't know how to remove the zero that is to the left of the letter. So right now in the resulting list it looks like 870A when I would like it to look like 87A.

I cannot claim to have written the script below as I am very new to arcade. I was using Esri's AI assistant to help form the script. But I was not having any luck with the more complicated value mentioned above. Any advice that could be provided would be much appreciated. Thanks!

Re: Not sure on functionality needed for AGOL popup expression

KenBuja — Tue, 21 Jan 2025 16:00:39 GMT

In line 14, you're checking if a string is a NaN. That will return false, since the function IsNAN evaluates if a value is a NaN according to these rules:

A number is considered NaN in one of the following scenarios: - 0/0 - Infinity / Infinity - Infinity * 0 - Any operation in which NaN is an operand - Casting a non-numeric text or undefined to a number

So what you have to do is to attempt to cast that last character as a Number and check if it's a NaN. This will return the list as you wanted.

Re: Not sure on functionality needed for AGOL popup expression

OliviaMancuso — Tue, 21 Jan 2025 17:22:03 GMT

That is working perfectly! Thank you for the help, it is much appreciated 🙂

Here are the results: