I have a large table (102K+ rows) with a field that I need to add a number to. I can do what I need to do the long way by creating tables in Excel, importing into Access, running queries, and then importing into Arc to update the fields, but there has to be an easier way to do this and I'm hoping it can all be done using ArcMap.
Here???s the situation: The points which are now junctions never existed until I created the geometric network. I copied and pasted them on a mass scale from the network junction layer to the appropriate layer on the map and filled in a few attributes that are the same for all selected points, one of them being the basin designation.
There are 46 basins that start with one or two alpha characters; within those basins are the points I created where the Facility_ID (this is for use in Cityworks) has only the basin letter(s); what I need to do is add a number to that basin designation and the numbering has to be consecutive.
For instance, in basin 'A' I have 13,276 points that need a number added to the ???A???, but I won't be starting with number 1, I'll be starting with number 0652 resulting in A0652, A0653, A0654, etc; each basin varies in the amount of points where the Facility_ID needs updating and all have different starting numbers. I know having a leading zero on the number might or will cause problems but I need to keep the leading zeros until I get to 9999 and obviously this will be a text field.
Any help would be appreciated.