topic Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup in Developers Questions

Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

MichaelWalden1 — Mon, 16 Jul 2018 16:59:45 GMT

Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

I am trying to the equivalent Arcade expression for the following VBScript:

Function FindLabel ( [Station] )
if (LEN(ROUND([Station],0))) = "7" then
FindLabel = LEFT(ROUND([Station],0),5) + "+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "6" then
FindLabel = LEFT(ROUND([Station],0),4) + "+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "5" then
FindLabel = LEFT(ROUND([Station],0),3) + "+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "4" then
FindLabel = LEFT(ROUND([Station],0),2) + "+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "3" then
FindLabel = LEFT(ROUND([Station],0),1) + "+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "2" then
FindLabel = LEFT(ROUND([Station],0),0) + "0+" + RIGHT(ROUND([Station],0),2)
elseif (LEN(ROUND([Station],0))) = "1" then
FindLabel = LEFT(ROUND([Station],0),0) + "0+0" + RIGHT(ROUND([Station],0),2)
else
FindLabel = ROUND([Station],0)
end if
End Function

It appears there is not an Arcade text/string LENGTH function to be able to return the number of characters. Is there another way to format a number with varying digits/characters to take the last 2 digits for the record and insert a "+" before those 2 digits.

Example

VALUE STATION

639249 6392+49

11715 117+15

234 2+34

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

KenBuja — Mon, 16 Jul 2018 18:18:15 GMT

The Count function returns how many characters are in a string.

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Sun, 12 Dec 2021 07:01:12 GMT

Try this:

var station = Round($feature.Station, 0);
var len = Count(Text(station));

var start = "";
var middle = "";
var end = "";
if (len > 7) {
    start = station;
    middle = "";
    end = "";
} else if (len > 1) {
    start = Left(station, len-2);
    middle = "+";
    end = Right(station, 2);
} else if (len == 1) {
    start = "";
    middle = "0+";
    end = Right(station, 1);
} else {
    start = "";
    middle = "0+0";
    end = "";
}

var label = start + middle + end;
return label;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

StevenWeaver1 — Wed, 27 Nov 2019 01:08:18 GMT

I used this one:

var station = $feature.BeginStation;
var len = Count(Text(station))
var end = Text(station, "00.00")
var labelStation =""
var leftVal = len - 5
var start = Left(station, leftVal)
if (start=="") {
start="0";
}
labelStation = start + '+' + end

return labelStation

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Wed, 27 Nov 2019 01:54:24 GMT

Hi Steven Weaver ,

Are you sure your expression is correct? The OP provided some values and desired results and when I use your expression they don't match the desired result:

Value OP	Desired STATION OP	STATION with your expression
639249	6392+49	6+49.00
11715	117+15	0+15.00
234	2+34	0+34.00

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Sun, 12 Dec 2021 07:01:14 GMT

The expression for the OP could probably be shortened to something like this:

var value = $feature.Station;
if (Count(Text(value))<3) {
    return Left(Text(value, "000"), Count(Text(value, "000"))-2) + "+" + Right(Text(value, "000"), 2);
} else {
    return Left(Text(value), Count(Text(value))-2) + "+" + Right(Text(value), 2);    
}
‍‍‍‍‍‍

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Sun, 12 Dec 2021 07:01:17 GMT

Hi Steven Weaver ,

I have the feeling that there is a division missing in your expression.

var station = 123456; // $feature.BeginStation;
var len = Count(Text(station))
var end = Text(station/100, "00.00")
var labelStation =""
var leftVal = len - 4
var start = Left(station, leftVal)
if (start=="") {
start="0";
}
labelStation = start + '+' + end‍‍‍‍‍‍‍‍‍‍

Using the value 123456 it results in "12+34.56". Are you looking for something like this?

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

Tim-Woodfield — Wed, 02 Sep 2020 21:43:22 GMT

Hi Xander,

I'm trying to add in an "else if" to your code here to return and empty value if the field is blank instead of "+". I added in:

} else if (value=='') {
return "";

When the field is empty, it is still coming back as "+" instead of "". I also tried value==' ' to see if there was a space being saved as a blank but it was still returning "+". Do you have an idea of how I could get this to work?

Thanks!

Tim

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Sun, 12 Dec 2021 07:01:20 GMT

Hi twoodfield_DawoodGIS ,

You could probably do something like this:

var value = $feature.Station;
if (IsEmpty(value)) {
    return "";
} else {
    if (Count(Text(value))<3) {
        return Left(Text(value, "000"), Count(Text(value, "000"))-2) + "+" + Right(Text(value, "000"), 2);
    } else {
        return Left(Text(value), Count(Text(value))-2) + "+" + Right(Text(value), 2);    
    }    
}
‍‍‍‍‍‍‍‍‍‍

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

JosephGrossman — Wed, 14 Oct 2020 02:51:46 GMT

Thanks Xander Bakker, This was helpful. I used this to pair with linear referencing to do some stationing in Pro.

https://pro.arcgis.com/en/pro-app/tool-reference/linear-referencing/an-overview-of-the-linear-referencing-toolbox.htm

https://pro.arcgis.com/en/pro-app/help/mapping/layer-properties/linear-referencing-hatch-symbols.htm

Re: Arcade expression for formatting a number into Station+ (Plus) format in WebMap Popup

XanderBakker — Wed, 14 Oct 2020 13:57:57 GMT

Hi jgrossman_VHB ,

Glad to hear that it was helpful!