topic Re: Attribute Assistant GENERATE_ID and then buffer with zeros? in State & Local Government Questions

Attribute Assistant GENERATE_ID and then buffer with zeros?

JonBrandt — Thu, 05 Dec 2019 19:54:02 GMT

Is there a command to force my Unique ID to buffer it with zeros?

Not sure how to set it up in attribute assistant: MANHOLE|0|SSMH[seq] I've taken this and added MANHOLE|0|SSMH[seq].zfill(7) This of course doesn't work, so what is the method for attribute assistant, do I use an arcade function?

FYI: In field calculator using python I can run the .zfill() on my text Unique ID field and then I'm able to sort numerically but I need that automated.

Ultimately I want my unique ID to look like this: SSMH0015231

Re: Attribute Assistant GENERATE_ID and then buffer with zeros?

JoeBorgione — Thu, 05 Dec 2019 20:12:38 GMT

Attribute Assistant functions are visual basic so python and arcade aren't going to help you, at least within AA itself. You might take a look at a python calculate or replace function after the fact.

edited to ad: after a few moments of thought....

Would this work?

MANHOLE|0|SSMH00[seq]

Just putting the 00 in between SSMH and your [seq]

Re: Attribute Assistant GENERATE_ID and then buffer with zeros?

JonBrandt — Thu, 05 Dec 2019 22:12:04 GMT

Tried that. It only works up to a point and isn't as clean as I'd like it.

Re: Attribute Assistant GENERATE_ID and then buffer with zeros?

JoeBorgione — Thu, 05 Dec 2019 22:54:48 GMT

Gotcha...

Re: Attribute Assistant GENERATE_ID and then buffer with zeros?

AndyShoemaker — Fri, 06 Dec 2019 18:17:43 GMT

Hi John,

Does every value need to have the extra padding or just values which are shorter than the full length you want?

For example, would you want "0011" and "0111" or would you want these to be "0011" and "00111"?

If you want the former, you can change the width of the integer generated so your expression would look like this "MANHOLE|4|SSMH[seq]". That should ensure the sequence is 4 digits and will pad with leading zeros

Andy

Re: Attribute Assistant GENERATE_ID and then buffer with zeros?

JoshVigness — Thu, 23 Apr 2020 15:22:46 GMT

Jon,

I am not sure if you have found a solution to this issue or moved on but here is how I do this. The one difference is I am using this against an existing field so you would have to play around with trying to get it to work with your sequence name.

"WMMH"&string(4-Len([gisid]),"0")&[gisid]

This returns WMMH0001

[gisid] is the field I am padding to create my new field.

Josh