VBScript (Visual Basic Scripting Edition) is an Active Scripting language developed by Microsoft that is modeled on Visual Basic.

learn more… | top users | synonyms

4
votes
4answers
2k views

How to concatenate numbers and add in leading zeros?

I have three text fields populated as follows: 1, 9, 1 that I need to concatenate into a field that looks like 01.09.01. Getting to 1.9.1 is easy but can anyone help out with how to formulate it so ...
2
votes
1answer
2k views

How to combine If Then with InStr in ArcMap field calculator?

I want to write an if then in field calculator that tests if a field in the attribute table contains one of several versions of another string (the versions vary by capitalization). Trouble is, I ...
4
votes
2answers
4k views

Remove first n characters in label using ArcGIS 10 label expression builder with VBscript

I have a planning cadastre dataset. It has the type of plan (DP, RP or SP) and then the plan number, thusly: DP123456 RP1248590000 SP3855 etc... I want to make a label in the expression builder in ...
1
vote
2answers
1k views

ArcGIS field calculator: VBScript get data from previous row

When using the field calculator, how do I get data from the previous row in VBScript? In Python I'd do something like this: for index, row in enumerate(rows,start=1): row[index-1] += 5 I'm ...
3
votes
1answer
779 views

VBscript Regular Expression in ArcMap Field Calculator

I'm looking for a regex in VBscript that I can use on a ArcMap table. I know what it would look like in python: pat =r'[0-9]{3,4}' This filters all numeric characters from the string which have the ...
7
votes
1answer
777 views

ArcMap 10: How do I escape certain characters when labeling?

I am labeling certain Oil & Gas areas by Operator in ArcMap 10, using this expression: "" & [OPERATOR] & "" & vbNewline & "" & [UNIT_NAME] & "" The only problem is ...
1
vote
3answers
2k views

Using VBScript to label shapefile in ArcMap

If you're reading this for the first time, it might be best to focus on section beneath ANOTHER UPDATE. I'm a beginner with VBScript and I have a question about using an VBScript expression for a ...
0
votes
1answer
103 views

create geometry in arcpad

i want to create a point geometry in ArcPad 10 VBScript, to make custom feature drawing. so i want create point geometry then record.shape = point or records.AddNew(point) i want to create ...
3
votes
1answer
629 views

ArcPad 10 Studio, from form to vbscript back to form

There is very little documentation on using vbscript within a form. Any help with syntax for ArcPad 10 would be appreciated. Within my subroutine, I want to grab some numerical data entered in a ...
2
votes
1answer
976 views

Programatically write values to ArcPad Form control box

Using this blog post I've managed to store user names as global variables in ArcPad. The next step is to use those variables in form 'controls' aka form fields. Per the author's comments under his ...
1
vote
1answer
1k views

ARCPAD - VBscript to update values in attribute table

I am working on an automating tool for ArcPad for inventory issues on our mobile GIS machine (Trimble GeoXH - Geoexplorer 2008 series - Windows mobile 6.1 and Arcdap 10.0.3). I have developed the ...
3
votes
2answers
5k views

Using conditional statements in Field Calculator

I have two fields, "P_Area" and "PC_Area", whose sizes I'd like to compare in a third field, "Areas_Equal". The "Areas_Equal" field should contain a "Yes" if the other two are equal and a "No" if they ...
0
votes
4answers
344 views

How to solve a run-time error in Thiessen polygons command line

Well I revise my post by giving more information for my problem hoping I may get some help please. I call Procedure 2 from a loop that is within Procedure 1 (see below). The program stacks in the ...
1
vote
0answers
173 views

How can I denote the values of reclassification using variables?

I used the following lines of code to classify a raster. However, my problem is how can I denote the old and new classification values in the last code line using variables? Then number of values ...
1
vote
0answers
262 views

Extract by mask run time error in VBA

I have the following script language code shown below within a main code just to run the tool of spatial analyst "Extract by mask". Unfortunately, when I run it I get a Run Time Error. I checked file ...
2
votes
0answers
105 views

How can I identify the pixel with the maximum value in a grid? [duplicate]

Possible Duplicate: How to find the locations of the highest values in a raster? How can I identify the pixel with the maximum value in a grid and get its coordinates? Any VBA code please?
13
votes
2answers
3k views

How can I create weighted Thiessen polygons?

I have a point shape file and I create Thiessen (Voronoi) polygons programmatically using this scripting syntax: CreateThiessenPolygons_analysis (in_features, out_feature_class, fields_to_copy) ...
5
votes
2answers
5k views

How to sort a feature class and then calculate a sequential ID field?

I am in ArcMap and I want to sort the records based on a field and then do a Calculate Field with an auto-incrementing value with the sort in-place. Any ideas? It looks like I could get an update ...
4
votes
2answers
4k views

Nested “if” statements in ArcGIS Field Calculator

The solution in VB for the base process is @ "If then" VB Script code (or Python) equivalent to SQL's IN ('x','y',z') expression in ArcGIS Field Calculator question? ...
4
votes
2answers
5k views

If/then VBScript/Python code equivalent to SQL IN ('x','y',z') expression in ArcGIS Field Calculator?

we need just like the following, only with multiple records selected... have tried the "xyz" in (1,2,3,4,5) SQL code but of course VB Script wants something else. dim f2 if [field1] = "foo" then f2 ...