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

Arcade expression to place attributes on separate lines from one field

CMcDonald

Hi,

I have a dataset whereby several attributes have been entered into one single field and would like to put each on a new line so that the attribute window is much clearer. Each entry is separated by a semicolon ; Currently this looks like:

Is it possible to separate into:

Amenity Accommodation - 14

Flat - 65

Four in a Block - 60

House - 66

Sheltered Accommodation - 38

There are also other Housing types available in different polygons. I wondered if some sort of IF = statement would be required to create the expression?

Thanks in advance

p.s. if Arcade is a suitable solution i am a novice

Find more posts tagged with

Accepted answers

XanderBakker

Hi @CMcDonald ,

Your code would look like this:

var test1 = $feature.PROPBREAKDOWN;
var test2 = Replace(test1, "; ", ";");
var list = Split(test2, ";");
var result = Concatenate(list, TextFormatting.NewLine);
return result;

The value in the text that follows Amenty Accommodation does not affect the expressión It is just part of the text. The initial text is separated by the semicolon. It does not matter much what comes before or after the semicolon. Let me know if it works or if you need any further explanation.

All comments

XanderBakker

Hi @CMcDonald ,

This can be done with Arcade. Have a look at the example below:

// var test1 = $feature["Name of your Field goes here"];
var test1 = "Amenity Accommodation - 14; Flat - 65; Four in a Block - 60; House - 66; Sheltered Accommodation - 38";
var test2 = Replace(test1, "; ", ";");
var list = Split(test2, ";");
var result = Concatenate(list, TextFormatting.NewLine);
return result;

The first line is commented ("//"), but explains how you could connect to the field that contains the list. The second line is just to create a variable with the list that you used in your example.

On the third line I first replace all the "; " (including the space) for just the ";" to avoid having redundant spaces and the start of each element.

On line 4 I use Split to split the text into a list of 5 elements

On line 5 the Concatenate function helps to create a text and we combine the elements with a new line. Ths will result in a multililine text:

CMcDonald

Thanks @XanderBakker

Because I'm a total novice with Arcade I'm struggling understanding the code. The field name would be PROPBREAKDOWN so my first line of code looks like below, I'm assuming I shouldn't have this commented out i.e. //

var test1 = $feature.PROPBREAKDOWN
var test1 =

I'm then not sure about line 2, should i just copy & paste green text. How does this work if other polygons in the dataset have different values against them i.e. if Amenity Accommodation had a value of 20 or 50 etc.

Thanks

XanderBakker

Hi @CMcDonald ,

Your code would look like this:

var test1 = $feature.PROPBREAKDOWN;
var test2 = Replace(test1, "; ", ";");
var list = Split(test2, ";");
var result = Concatenate(list, TextFormatting.NewLine);
return result;

CMcDonald

Excellent!, thanks @XanderBakker 👍

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.