Comments on: VBA Field Calculator Tips in ArcMap (Kelso)

By: Seth

Seth — Mon, 08 Aug 2011 05:47:30 +0000

Hi all friend
I have two field: field1 and field2
field1:
72°4′ 31.192″
72°3′ 31.195″
So I want to calculate field2 like this:
72°04′ 31.192″
72°03′ 31.195″
How can I calculate this field2?
Please tell me about vb Script or Python or other

By: Dennis

Dennis — Tue, 21 Jun 2011 17:08:40 +0000

Greetings all,

I have created a fishnet set of polygons. There is no information in it and I need to populate it with a series of repeating values in each row there are only two possible values and there are three sets so it looks something like this

ABABABABAB
CDCDCDCDCD
EFEFEFEFEFEFEF
ABABABABAB
CDCDCDCDCD
EFEFEFEFEFEFEF

While I would normally just fill this in by hand, there are 7000+ blocks. Is there a script out there that will allow me to populate this automatically?

Thank you all,
Dennis

By: chris

chris — Wed, 01 Sep 2010 15:47:17 +0000

I am trying to populate a number field in sequential order. I have used the scripts found on this page but it assigns the number in the order that I created each shape. I want it to assign the number in the the order that I have already placed my shapes in. Anyone have any answers??

By: Nathaniel

Nathaniel — Fri, 20 Aug 2010 15:12:35 +0000

Thanks for the tip, @Shanoboy!

By: shanoboy

shanoboy — Fri, 20 Aug 2010 15:10:46 +0000

Also, in response to your solution for removing extra spaces. You can use the trim function.

Trim ( [FieldName] )

Or if you have too many spaces, you can use replace to shorten them:
Replace([FieldName], ” “, ” “) <- where you literally replace the excess spaces (” “) with the amount of spaces you desire (” “).

By: shanoboy

shanoboy — Fri, 20 Aug 2010 14:45:26 +0000

Thanks for this. Great help and refresher!

By: Vince

Vince — Tue, 17 Aug 2010 16:46:20 +0000

I have an attribute field (WKZN) that contains numeric values
>>>>>>>> (integer). I need to filter out the “0′s” (accomplished with a
> > > > > > Tester) and then write a value in the field to replace the “0′s”. The
> > > > > > number I need to write needs to be the next highest value from the
> > > > > > highest existing number in the field (e.g. if 3630 is the largest
> > > > > > number in the attribute field, I want to write 3631 for my first “0″
> > > > > > and 3632 for my second “0″ and so on…). Any suggestions as to how
> > > > > > to accomplish this?

By: Esther

Esther — Sun, 25 Jul 2010 22:21:31 +0000

Hello GIS fellows,
I am ( a newby) trying to do some ArcMap VBA calculations, but I can not get the script to work (“Error Running VBA Script Code”). I would like to populate a field using an equation that depends on landuse type:

e.g. if IF [LANDUSE]=”Low Density Residential” THEN (in the Pre-Logic VBA Script Code)
BOD =( [Ai]/ [Sum_Ai])*( [Rv]/ [Sum_Rvi])*13.5

e.g. if IF [LANDUSE]=”High Density Residential” THEN (in the Pre-Logic VBA Script Code)
BOD =( [Ai]/ [Sum_Ai])*( [Rv]/ [Sum_Rvi])*13.5

Please help

By: Tiffany

Tiffany — Thu, 08 Jul 2010 20:15:17 +0000

I have calculated values in the attribute table and sorted highest to lowest. I would now like to rank them. I’ve added a new field. How do I calculate sequential numbers to popluate the field? Thanks for any help you can give!

By: Nathaniel

Nathaniel — Thu, 10 Jun 2010 22:25:20 +0000

@Bubba: Try running repair geometry on your features. You might have some null polygons in there. Also, if myString is 0 length (empty), you might get this error because of that.