Replace string with values in a new field column ?

progis99

I have a Forest roads here with me and there is a column (iD ) that shows street name number, freeway, state, county along with their numbers..

I copied them to a new field column Symbol that I need to calculate them with just numbers only.

This purpose is to show them the road symbol number as a labels

How do I do that  in the Field Calculator ?

katherinehannaford

Hello Robert,

If I understand your situation correctly and you want to take a non-script approach I think you could do that fairly easily with some preprocessing to separate out the "pure" numbers (e.g., "111" in your snapshot) from the "mixed format" numbers (e.g., "PRK-70").  The "pure" ones are a piece of cake; just add your new numeric field and use the Field Calculator to copy in the numbers.  If they were all "pure" you'd be done; but, alas, they aren't.  So, for these you can use an intermediate text field, some selection sets and VBA functions (e.g., RIGHT).  Don't see what you intend to do with the ones that don't have any number in them except leave them 0.  Of course, you may want to create a text Symbol field that just leaves off the state, county and other values embedded in your ID field.  If you expect to do this repeatedly or want to practice scripting, you should definitely go the script route, but if it's a one-off thing and you just want it done, the VBA process should work just fine.

Check out this Knowledge Base Technical Article for VBA functions.  I'm using ArcGIS 10.3 and they still work for me.  Good luck.

31807 - Use VBA functions in the Field Calculator