Im using ArcMap 9.3. Im looking for a VBA code to use in the field calculator to make a new field of the last 7 digits of a "pin" field. For example. my pin is 00-00-999-999 and i want it to display as 999-999 in my new field. Anybody have code for this?
[GIS] How to use VBA in the field calculator, to copy the last 7 characters to a new field
arcmaparcpyfield-calculator
Related Solutions
Try something like this:
dim f2
if [field1] = "foo" then
f2 = "bar"
end if
Screen shot of this being used in the field calculator.
Here is a technical document describing some of the basic VBA calculator functions, with links to some short walk-throughs. And here is some narrative (with examples) on using the Field Calculator and VBA.
Remember that using VBA in the field calculator is only valid for 9.3.1 and not 10 (which uses python and VBScript).
Best Answer
Here is a link to an Esri tech article "HowTo: Use VBA functions in the Field Calculator." Take a look at the Right Function which "...Returns a Variant (String) containing a specified number of characters from the right side of a string." An example is included on the page. You will have to add the new field separately, then use the right function to calculate the value.
http://support.esri.com/en/knowledgebase/techarticles/detail/31807