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

Use Attribute Rules to remove text from a field

JustinBernard1886

Hi all,

I am extremely new at using attribute rules and Arcade for ArcGIS Pro, and I need some help on what I am sure is a simple process.

I have a column filled with text like this, "R4-52" and "H-R4-52" What I would like to do is use arcade to populate a new field where the output will be "R4", basically removing the dash and any characters before and after the dash. I know the replace function can be used to do this, but I wasn't able to find any examples.

Can someone help with this?

Much appreciated,

Justin

Find more posts tagged with

Desktop

Accepted answers

JustinBernard1886

Hi All,

So I was able to find a solution that fit my needs. Thanks so much for all the help!

Justin

All comments

JustinBernard1886

Here:

(I did not write this)

JoeBorgione

Care to share?

JustinBernard1886

Hi All,

So I was able to find a solution that fit my needs. Thanks so much for all the help!

Justin

JoeBorgione

Five minutes in the ESRI Arcade playground and I came up with this:

var name = ' R3-1';
Console(name)
var nameArray = Split(name,'-')
Console(nameArray)
var arrayLength = Count(nameArray)
Console(arrayLength)

if (arrayLength == 2) {
    Console(nameArray[0])
}

The Console() function is like the print() function in python, but it only works in the playground. This is nothing more than python logic in Arcade...

JoeBorgione

Another approach: split the string at the dashes into an array and then get the count of that array. If the count indicates 1 dash, grab the first element of the array; if the count indicates 2 dashes, grab the second element of the array. I'm pretty sure arcade arrays are 0 based.

JustinBernard1886

Just one and two dashes
eg: R3-1, and H-R4-2

JayantaPoddar

Do you have one "-" or more than two "-" instances in the string? What to do in those cases?

e.g.: HE-77-L-0

JustinBernard1886

Thanks for the reply!
The values are dynamic, my apologies.
I basically would like to remove the <text>"-" , "-'<text> and keep the middle characters.
Thanks for the help!

JayantaPoddar

Are you looking for the exact value, 'R4'?

Then, check the following syntax

Parser: Arcade

IIF(FIND('R4',$feature.FIELDNAME,0)==-1,'','R4')

Let me know a few more examples if the substring value is dynamic.

JoeBorgione

What about the left() function?

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.