topic Re: Use Attribute Rules to remove text from a field in ArcGIS Pro Questions

Use Attribute Rules to remove text from a field

JustinBernard1886 — Fri, 05 Nov 2021 16:02:56 GMT

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

Re: Use Attribute Rules to remove text from a field

JoeBorgione — Fri, 05 Nov 2021 16:51:47 GMT

What about the left() function?

Re: Use Attribute Rules to remove text from a field

JayantaPoddar — Fri, 05 Nov 2021 17:27:36 GMT

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.

Re: Use Attribute Rules to remove text from a field

JustinBernard1886 — Fri, 05 Nov 2021 17:34:42 GMT

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!

Re: Use Attribute Rules to remove text from a field

JayantaPoddar — Fri, 05 Nov 2021 17:38:05 GMT

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

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

Re: Use Attribute Rules to remove text from a field

JustinBernard1886 — Fri, 05 Nov 2021 17:42:00 GMT

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

Re: Use Attribute Rules to remove text from a field

JayantaPoddar — Fri, 05 Nov 2021 19:07:33 GMT

Parser: Arcade

SPLIT($feature.FIELDNAME,'-')[-2]

Re: Use Attribute Rules to remove text from a field

JoeBorgione — Fri, 05 Nov 2021 19:02:05 GMT

I thought this is in the context of an Attribute Rule; in that case Arcade is the only option.

Re: Use Attribute Rules to remove text from a field

JayantaPoddar — Fri, 05 Nov 2021 19:07:43 GMT

Ahh. I see. Removed the Python one.

Thanks.

Re: Use Attribute Rules to remove text from a field

JoeBorgione — Fri, 05 Nov 2021 19:18:54 GMT

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.

Re: Use Attribute Rules to remove text from a field

JoeBorgione — Fri, 05 Nov 2021 19:38:48 GMT

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...

Re: Use Attribute Rules to remove text from a field

JustinBernard1886 — Wed, 10 Nov 2021 19:27:24 GMT

Hi All,

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

Justin

Re: Use Attribute Rules to remove text from a field

JoeBorgione — Wed, 10 Nov 2021 19:55:55 GMT

Care to share?

Re: Use Attribute Rules to remove text from a field

JustinBernard1886 — Mon, 15 Nov 2021 12:30:15 GMT

Here:

(I did not write this)