topic Looking for arcade expression to Insert character at specific point in text string in Attribute Rules Questions

Looking for arcade expression to Insert character at specific point in text string

RobertChaney — Mon, 06 Mar 2023 22:13:59 GMT

I'm typing in a Number like the following, 1701010000001000 into a PARCELID text field.

This number gets populated into another field (NAME) through a simple calculation attribute rule.

However, what I'd like to see in the NAME field is this, 17-01-01-0-000-001.000

Can anyone share some arcade expression to get me started, my experience with arcade in very limited.

Thanks,

Robert

ArcGIS Pro ver. 3.0.3

Re: Looking for arcade expression to Insert character at specific point in text string

DavidPike — Mon, 06 Mar 2023 23:41:29 GMT

It's no work of art but it may give you an idea of what may be needed. Assumption that the string length and format never changes.

//cast your number to a string var string = Text($feature.PARCELID) //make a list of each character in the string var splitString = Split(string,"") //shorten variable name for ease of reading var sS = splitString //logic to construct output string, incomplete sS[0] + sS[1] + "-" + sS[2] + +sS[3] + "-"

Re: Looking for arcade expression to Insert character at specific point in text string

KenBuja — Tue, 07 Mar 2023 00:15:48 GMT

Another way would be like this, using Template literals and Text functions

var test = 1701010000001000; //this also work if it's a string (ie "1701010000001000") return `${Left(test,2)}-${Mid(test,2,2)}-${Mid(test,4,2)}-${Mid(test,6,1)}-${Mid(test,7,3)}-${Mid(test,10,3)}.${Mid(test,13,3)}`

Re: Looking for arcade expression to Insert character at specific point in text string

JohannesLindner — Tue, 07 Mar 2023 12:47:26 GMT

A configurable way:

var parcel_id = Split(Text($feature.PARCELID), "") //var parcel_id = Split("1701010000001000", "") var counts = [2, 2, 2, 1, 3, 3, 3] var separators = ["-", "-", "-", "-", "-", ".", null] var formatted_id = "" var index = 0 for(var c in counts) { var part = Concatenate(Slice(parcel_id, index, index + counts[c])) formatted_id += part + separators[c] index += counts[c] } return formatted_id

Re: Looking for arcade expression to Insert character at specific point in text string

RobertChaney — Tue, 07 Mar 2023 17:12:41 GMT

David,

Thanks for your reply. The expression works fine for labels, however, when adding it to the calculation attribute rule I get a ERROR 002717: Invalid Arcade expression, Arcade error, Index out of bounds, Script line: 8

Any ideas?

Re: Looking for arcade expression to Insert character at specific point in text string

RobertChaney — Tue, 07 Mar 2023 17:19:45 GMT

Ken,

Your expression works, if I replace the actual number with $feature.PARCELID, it does what I need.

var test = $feature.PARCELID; //this also work if it's a string (ie "1701010000001000") return `${Left(test,2)}-${Mid(test,2,2)}-${Mid(test,4,2)}-${Mid(test,6,1)}-${Mid(test,7,3)}-${Mid(test,10,3)}.${Mid(test,13,3)}`

Thank you for your input.

Robert.

Re: Looking for arcade expression to Insert character at specific point in text string

RobertChaney — Tue, 07 Mar 2023 17:21:04 GMT

Johannes,

Your expression works as well, thank you for your input.

Robert.

Re: Looking for arcade expression to Insert character at specific point in text string

JohannesLindner — Tue, 07 Mar 2023 17:23:29 GMT

We gave you solutions for parcel ids with exactly 16 characters. Is this always the case?

You also should implement a null check:

if(IsEmpty($feature.PARCELID)) { return null } // any of our expressions after this.

Re: Looking for arcade expression to Insert character at specific point in text string

RobertChaney — Tue, 07 Mar 2023 21:16:00 GMT

Yes, this field should always contain 16 characters. I'll implement the null check.

Thanks.