Dynamic Value Table - Is there a way to format leading zeros for values?

3774
2
05-18-2015 02:07 PM
Labels (1)
MarietteShin
New Contributor III

I am looking into the feasibility of using the Water Utility Network Editing Tools' Dynamic Value and Generate ID tables to automatically create feature IDs for our water infrastructure features. However, for some of our IDs, we need to be able to format the auto-generated IDs with leading zeros (e.g. our Hyrant IDs always have 5 characters, HY-00013). I have been unable to find any documentation on how to do this.

Thanks.

0 Kudos
2 Replies
DrewLindow
New Contributor II

In the Dynamic Value table the parameters you specify in the Value Info field are in the form Name|{Width}|{Format}[seq].

{Width} is the length of the identifier. If the current value of [seq] is shorter than this value, zeros will be added to the left of [seq] to create the specified width.

So in your example the Value Info field would be something like:

HYDRANT|5|HY-[seq]

See this for more info:

ArcGIS for Local Government 10.2

0 Kudos
MarietteShin
New Contributor III

Thanks Drew! I'll give this a try.

0 Kudos