topic Split and Get value with arcade in Developers Questions

Split and Get value with arcade

KARIMLABIDI — Fri, 11 Jun 2021 15:06:05 GMT

Hello,

On Arcgis Portal, I would like to represent my buses line with Arcade and HTML. I would like get the number of the line and put colors in relation to the numbers.

My value are like that on my stop feature : Line 1, Line 2, ..., Test 56.

My first problem is to get the number only. I can split the field but then I don't know how the get the value.

Is someone think it's possible or too complicated? With IIf maybe?

I know this blog but my problem is little more different. https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/combining-arcade-and-html-for-a-real-life-pop-up-display/

Thank you

Re: Split and Get value with arcade

jcarlson — Fri, 11 Jun 2021 16:58:14 GMT

So is your example, "Line 1, Line 2, ..., Test 56" for a single point? How do you envision a stop being displayed when there are multiple values?

Re: Split and Get value with arcade

KARIMLABIDI — Fri, 11 Jun 2021 17:04:39 GMT

I don't know maybe with multiple Iif ?If I can split the field and get each value, after that maybe with Iif (Left($feature.field),4) == "Test"), "#color", Iif ((Left($feature.field),4) == "Line"), "#color2"),...

I don't know if it's possible.

Re: Split and Get value with arcade

jcarlson — Fri, 11 Jun 2021 17:28:15 GMT

The trouble is, you're only going to be able to output a single color. So your popup could have some kind of element, maybe a shape or a line of text, but you can only define its color once.

If you want one element per line associated with the stop, you'll need some way to identify each line separately. Meaning, each line will need its own expression.

You can try to create a list of lines in a single expression, but what you'll find is that HTML tags have to be established in the popup, not in the expression. When you try to use HTML in the expression itself, you get this:

The <...> items are treated as raw text, not HTML.

So for each possible line, you need some kind of placeholder in the popup. Depending on the number of possible lines, this can lead to a rather inelegant popup.

This might be too far outside the scope of your question, but how much control do you have over the data? Would it be possible to establish a relationship class between the stops and lines? The string-based list of Lines just seems difficult to work with.

Re: Split and Get value with arcade

KARIMLABIDI — Wed, 16 Jun 2021 08:53:48 GMT

Hello Josh, thank for your answer.

There 's still have a relationship class between the stops and the lines. how see you the things?

Re: Split and Get value with arcade

JohannesLindner — Thu, 17 Jun 2021 08:38:23 GMT

As Josh said, if you want to format the lines differently in the popup, you will have to create an expression for each of your lines.

// expression/show_line_1 // returns "none" if "Line 1" is not found in the Line field // returns "block" if it is found var result = Find("Line 1", $feature.LineField) if(result == -1) { return "none" } return "block"

In your popup configuration, switch to HTML source.

<p style="font-weight: bold;">Lines at this stop:</p> <div style="display: {expression/show_line_1}; color: red;">Line 1</div> <div style="display: {expression/show_line_2}; color: green;">Line 2</div> <div style="display: {expression/show_line_3}; color: blue; background:black;">Line 3</div>

If you return "inline" instead of "block " in the expression, the lines will be shown next to each other.

Re: Split and Get value with arcade

KARIMLABIDI — Sun, 20 Jun 2021 20:21:42 GMT

Hi Johannes, it works like a charm!

But I Have a problem with the Find fonction: it finds me every word beginning by a B or a C as we see in the image. Even when my line calls 1 or 11, it finds the both.

How can I solve this little problem? I have tried with the lenght of the value or a other value of a other field but I didn't success.

If you have any idea, it would be very nice ! Thank you

Re: Split and Get value with arcade

JohannesLindner — Mon, 21 Jun 2021 05:10:59 GMT

If your lines are always separated by the same character ("/" in your image), you can use this:

// show_line_1 var lines = Split($feature.LineField, "/") return IIF(Includes(lines, "Line 1"), "block", "none")

If Includes is not available for you yet (it came with the latest Arcade version), it would be a bit more cumbersome:

// show_line_1 var lines = Split($feature.LineField, "/") for(var i in lines) { if(lines[i] == "Line 1") { return "block" } } return "none"

Re: Split and Get value with arcade

KARIMLABIDI — Mon, 21 Jun 2021 15:24:46 GMT

Yes it works! Thank you so much Johannes!

Re: Split and Get value with arcade

JohannesLindner — Tue, 22 Jun 2021 06:33:22 GMT

Good to hear, glad I could help.

Please mark an answer as solution, so that it gets shown at the top directly under the question.

Re: Split and Get value with arcade

PSGeo — Wed, 20 Oct 2021 13:37:28 GMT

Hi,

real nice. I was looking for this. I was wondering if it is possible to add hyperlinks, according to the field attribute. My problem here is that I would like to show an alias of the hyperlink. but the Equip field can have more than one equipment (therefore I am using your solution for split).

I hope u can understand my difficulty.

cheers

Pedro

// show_line_1 var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "car") { return "https://luxe.digital/lifestyle/cars/fastest-cars/" } } return "none"

Re: Split and Get value with arcade

JohannesLindner — Thu, 21 Oct 2021 05:07:26 GMT

So if "car" is in your equipment field, you always want to return that link, but with an alias like "These are the fastest cars"? In that case you would put the link into the popup's HTML and show or hide it with the expression:

<div style="display: {expression/show_car};"><a href="https://luxe.digital/lifestyle/cars/fastest-cars">These are the fastest cars</a></div> <div style="display: {expression/show_ship};"><a href="https://..../biggest-ships">These are the biggest cruise ships</a></div>

// show_car var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "car") { return "block" } } return "none"

Re: Split and Get value with arcade

PSGeo — Thu, 21 Oct 2021 09:53:18 GMT

Hi thanks for the answer.

But I cannot understand where to add it in the popup HTML. I click a dot on my map, the popup is shown and than I do CTRL+U... but in the HTML I cannot find the part of the popup and where to add your code.

maybe is a dumb question but I don't know this.

cheers

Pedro

Re: Split and Get value with arcade

JohannesLindner — Thu, 21 Oct 2021 10:10:38 GMT

When you configure your popup, there is an option to switch to the HTML source.

ArcGIS Pro:

Map Viewer Classic:

Re: Split and Get value with arcade

PSGeo — Thu, 21 Oct 2021 11:08:56 GMT

Fantastic, it worked. <learning everyday>

my doubt now is the following. As I have different hyperlinks per vehicle how can I show it in the popup the name (hyperlinked)? Let's say car to the car page, and bike to the bike page - sometimes single one, sometimes both.

cheers

Pedro

// show_car var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "car") { return "block" } if(lines[i] == "bike") { return "block" } if(lines[i] == "boat") { return "block" } if(lines[i] == "etc...") { return "block" } } return "none"

Re: Split and Get value with arcade

JohannesLindner — Thu, 21 Oct 2021 11:28:20 GMT

You can't do it in one expression.

For each of your equipment types, you create an expression that shows or hides the div block in the popup.

// show_car var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "car") { return "block" } } return "none"

// show_bike var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "bike") { return "block" } } return "none"

// show_boat var lines = Split($feature.Equip, ",") for(var i in lines) { if(lines[i] == "boat") { return "block" } } return "none"

<div style="display: {expression/show_car};"><a href="https://luxe.digital/lifestyle/cars/fastest-cars">These are the fastest cars</a></div> <div style="display: {expression/show_bike};"><a href="https://.../coolest_bikes">These are the coolest bikes</a></div> <div style="display: {expression/show_boat};"><a href="https://..../biggest-ships">These are the biggest cruise ships</a></div>

Re: Split and Get value with arcade

PSGeo — Fri, 22 Oct 2021 11:01:06 GMT

Hi again,

I do not understand why in the final pop-up it appears "car" "bike" and "boat" when in the field is only "bike".

Isn't the "return "none"" make them not visible while the those attributes are not in the field whereas bike is the only in?

cheers

Pedro

Re: Split and Get value with arcade

JohannesLindner — Fri, 22 Oct 2021 11:13:43 GMT

The final code is the popup's html.

For each of your equipment types, you need one of these:

<div style="display: {expression/show_bike};">Content</div>

If you have "bike" in your equipment field, this will evaluate to

<div style="display: block;">Content</div>

In HTML, "display: block" means that the element (the div in this case) will be shown on screen.

If "bike" is not in your equipment field, the HTML will evaluate to

<div style="display: none;">Content</div>

which will hide the element.

So if you only have "bike" in the field, the div elements for "car" and "boat" should be hidden.

If that is not the case, you probably need to check the expression names. Could be that your expressions aren't named "expression/show_car", but "expression/expr0" or "expression/expression0" or similar.

Re: Split and Get value with arcade

PSGeo — Fri, 22 Oct 2021 13:36:34 GMT

Ok, well. it seems that the name of my expression is wrong: "expression/expr0". I tried to rename, but it doesn't rename... So I will use the default esri naming. I tested and it worked.

Fantastic job. Please apply to SatCen and join my team.

cheers

Pedro

Re: Split and Get value with arcade

PSGeo1 — Fri, 12 Nov 2021 15:40:17 GMT

Hi,

@JohannesLindner, last

3 weeks ago you answer my question about the hyperlinks. one per vehicle (car, bicycle, etc)... more than one if there is more than one vehicle listed in the field.
the popup shows the naming correctly for one vehicle, for two vehicles, etc. However the hyperlink doesn't work properly when more than one vehicle is listed. It simply makes a single hyperlink of both words some thing like this:

Car, bicycle

I tested the link for both Car and Bicycle isolated and it works fine.

What could be the mistake?

if you want I can share the code but it is exactly what you suggested than.

cheers

Pedro