topic Re: Attribute rule arcade statement in Attribute Rules Questions

Attribute rule arcade statement

EricBregant2 — Tue, 27 Aug 2024 20:33:53 GMT

Hello! I am working on an attribute rule that will concatenate 6 fields that make up a street address to create a full address. The problem is that 2 of the fields are not always populated with a value. They will either be null or empty.

In the image below, you can see my 6 fields (ST_NUM, DIRPRE, FEANME, FEATYP, DIRSUF and Unit (LV_APT)

If I do a simple concatenate of those fields, the result will leave spaces at the end of the full address. I know this is because of there not always being a value in DIRSUF or LV_APT.

I have been working on the below code, but I know I am missing some parts. Any ideas or anyone know a better way?

// List the fields to combine
var parts = [$feature.ST_NUM, $feature.DIRPRE, $feature.FEANME, $feature.FEATYP, $feature.DIRSUF, $feature.LV_APT];

// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}

// Concatenate with a space
return Concatenate(filteredparts, " ");

Re: Attribute rule arcade statement

Brian_McLeer — Tue, 27 Aug 2024 20:51:02 GMT

I think you have to add the "" function to check for if a part is empty.

// List the fields to combine var parts = [$feature.ST_NUM, $feature.DIRPRE, $feature.FEANME, $feature.FEATYP, $feature.DIRSUF, $feature.LV_APT]; // Function to check if a value is null or empty function IsNullOrEmpty(value) { return value == null || value == ""; } // Loop through the address parts, if not null or empty add them to a new array var filteredparts = []; for (var i in parts) { var value = parts[i]; if (IsNullOrEmpty(value)) continue; filteredparts[Count(filteredparts)] = value; } // Concatenate with a space return Concatenate(filteredparts, " ");

Re: Attribute rule arcade statement

EricBregant2 — Tue, 27 Aug 2024 21:01:49 GMT

Thanks @Brian_McLeer

Re: Attribute rule arcade statement

MikeMillerGIS — Tue, 27 Aug 2024 21:21:35 GMT

Take a look at https://developers.arcgis.com/arcade/function-reference/array_functions/#filter

Re: Attribute rule arcade statement

EricBregant2 — Tue, 27 Aug 2024 21:23:43 GMT

I found this as well

var fullName

if(IsEmpty($feature.ST_NUM)==false){
fullName += $feature.ST_NUM + " "
}
if(IsEmpty($feature.DIRPRE)==false){
fullName += $feature.DIRPRE + " "
}
if(IsEmpty($feature.FEANME)==false){
fullName += $feature.FEANME + " "
}
if(IsEmpty($feature.FEATYP)==false){
fullName += $feature.FEATYP + " "
}
if(IsEmpty($feature.DIRSUF)==false){
fullName += $feature.DIRSUF + " "
}
if(IsEmpty($feature.LV_APT)==false){
fullName += $feature.LV_APT + " "
}

return fullName

Re: Attribute rule arcade statement

TedHoward2 — Tue, 27 Aug 2024 21:57:35 GMT

You may need to adapt your code filter out strings with spaces.

IsEmpty(null) // true IsEmpty("") // true IsEmpty(" ") // false

Re: Attribute rule arcade statement

MikeMillerGIS — Tue, 27 Aug 2024 22:21:10 GMT

Here is how we do it

function not_empty(x) { return !IsEmpty(x); } return Concatenate(Filter(['a', 'b', '', null,'c'], not_empty), '-');

returns

"a-b-c"

Re: Attribute rule arcade statement

MikeMillerGIS — Tue, 27 Aug 2024 22:25:04 GMT

If you want to handle " ", then change not_empty to

function not_empty(x) { if (TypeOf(x) == 'String'){ x = Trim(x) } return !IsEmpty(x);

Re: Attribute rule arcade statement

EricBregant2 — Wed, 28 Aug 2024 18:29:38 GMT

I got the below code to do everything I want except to add an "#" before the unit number ($feature.LV_APT).

Any ideas?

// List the fields to combine
var parts = [$feature.ST_NUM, $feature.DIRPRE, $feature.FEANME, $feature.FEATYP, $feature.LV_APT];

// Function to check if a value is null or empty
function IsNullOrEmpty(value) {
return value == null || value == "";
}

// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsNullOrEmpty(value)) continue;
Push(filteredparts, value); // Use Push to add elements
}

// Concatenate with a space
var finaladdress = Concatenate(filteredparts, " ")
return finaladdress;

Re: Attribute rule arcade statement

EricBregant2 — Wed, 28 Aug 2024 19:10:05 GMT

// List the fields to combine
var parts = [$feature.ST_NUM, $feature.DIRPRE, $feature.FEANME, $feature.FEATYP, $feature.LV_APT];

// Function to check if a value is null or empty
function IsNullOrEmpty(value) {
return value == null || value == "";
}

// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];

// Add '#' before LV_APT if it's not null or empty
if (i == 4 && !IsNullOrEmpty(value)) {
value = "#" + value;
}

if (IsNullOrEmpty(value)) continue;
Push(filteredparts, value); // Use Push to add elements
}

// Concatenate with a space
var finaladdress = Concatenate(filteredparts, " ");
return finaladdress;

Re: Attribute rule arcade statement

MikeMillerGIS — Wed, 28 Aug 2024 21:09:41 GMT

It is best sharing code, add is as a code sample. For arcade, I pick Javascript. It is much easier to read, it maintains formatting, etc.

Re: Attribute rule arcade statement

LindseyStone — Fri, 30 Aug 2024 18:43:17 GMT

Here is how we did it, our two direction fields, unit, and addNum_suf fields may or may not be Null.

//Array to hold values and an index var i = 0; var features = []; //Add value to array if not empty function addvalue(feat) { if (!IsEmpty(feat)) { features[i++] = feat; } } //Add your values addvalue($feature.Add_Number); addvalue($feature.AddNum_Suf); addvalue($feature.St_PreDir); addvalue($feature.St_Name); addvalue($feature.St_PosType); addvalue($feature.St_PosDir); addvalue($feature.Unit); //Return a concatenated string with a space between each attribute return Concatenate(features, " ")