topic Re: Remove first 7 digits from a field in Geoprocessing Questions

Remove first 7 digits from a field

SeanKroencke — Tue, 20 Sep 2011 17:54:20 GMT

I'm trying to run a Field Calculator on a field to simply remove the first 7 digits of the field. How do I do this?

Thanks

Re: Remove first 7 digits from a field

DarrenWiens2 — Tue, 20 Sep 2011 20:00:08 GMT

VBScript: use a combination of CStr (to convert your number to a string), Len (to get the total number of characters), and Right (to grab only characters at the right hand end of your string [total minus 7]).

Re: Remove first 7 digits from a field

SeanKroencke — Tue, 20 Sep 2011 20:06:26 GMT

The problem is there isn't a static # of characters on the right that can remain in the result. The first 7 characters need to be removed in all instances, though.

Thanks for your help, I should have specified that originally.

Re: Remove first 7 digits from a field

DarrenWiens2 — Tue, 20 Sep 2011 20:15:52 GMT

You get the total number of characters with Len(). Len() - 7 is the number of characters to keep. Right() will keep that number of characters from the righthand side. You're not hardcoding anything except 7, the number of characters to exclude.