Select to view content in your preferred language

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

4094
2
05-18-2015 02:07 PM
Labels (1)
MarietteShin
Regular Contributor

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
Occasional Contributor

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
Regular Contributor

Thanks Drew! I'll give this a try.

0 Kudos