topic Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade in ArcGIS Pro Questions

Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

GISUSER6 — Wed, 03 Mar 2021 21:54:05 GMT

Hello,

I am trying to generate Facility IDs for my Water Meter feature class in ArcGIS Pro using Attribute Rules. This is the code I have so far, but I need to figure out how to add leading zeros, or decimal places to the ID. What I come up with is "wMET3" and I would like "wMET003". Any insight would be greatly appreciated.

if(isempty($feature.FACILITYID)) return concatenate("wMET" + nextsequencevalue("wMeterSeq"));

Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

jcarlson — Wed, 03 Mar 2021 22:10:26 GMT

Put your sequence value into the Text function. In the format parameter, a '0' is a mandatory digit, which will appear as a leading zero if the sequence is not that high yet.

var seq_num = 3 return 'Meter' + Text(seq_num, '0000')

Returns:

'Meter0003'

Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

LanceCole — Wed, 03 Mar 2021 22:28:01 GMT

I have not worked with this in Pro Attribute Rules but the Concatenate function in Arcade is Concatenate( values, separator?, format? ). Try using the following in your return:

Concatenate(['wMET', nextsequencevalue("wMeterSeq")], '', '000')

Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

GISUSER6 — Thu, 04 Mar 2021 13:21:55 GMT

Both of these processes worked. Thanks so much!

Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

jcarlson — Thu, 04 Mar 2021 13:27:32 GMT

I'm so used to concatenating w/ a "+" I completely forgot about that. Nice!

Re: Leading Zeros for Facility ID in Feature Class using Attribute Rules and Arcade

RichardLittlefield — Fri, 03 Feb 2023 14:32:17 GMT

I was in a similar situation. Using Attribute Rules to create an id, however didn't need the concatenate. The Text(Sequential Number, '0000') worked perfectly for adding leading zeros to your unique id with arcade expression in the attribute rules. Thanks!